If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table
Hello everyone.
I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel?? Thanks for the help. |
#2
|
|||
|
|||
Table
Bonjour,
Dans son message, wahoochuck écrivait : In this message, wahoochuck wrote: || Hello everyone. || I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word || table to make calculations instead of just using Excel?? || If all you are after is doing calculations, then no. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#3
|
|||
|
|||
Table
Excel is better if you're doing complicated calculations,
but Word is easy & quick to use for doing simple totals, e.g., Sum(Above). -----Original Message----- Hello everyone. I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel?? Thanks for the help. . |
#4
|
|||
|
|||
Table
I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong?
-- Derick in Essex UK " wrote: Excel is better if you're doing complicated calculations, but Word is easy & quick to use for doing simple totals, e.g., Sum(Above). -----Original Message----- Hello everyone. I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel?? Thanks for the help. . |
#5
|
|||
|
|||
Table
-----Original Message-----
I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong? -- Derick in Essex UK (a) Did you insert it by using Table Formula or Insert Field Formula? (you can't just type in the text) (b) Is it a complicated table? I think Sum(Above) only works well if none of the cells are [or were ever] merged. (c) Try creating a very simple 1 column, 3 row table with no formatting. In the first row type 2. In the cell below, type 2. In the cell below do Table Formula Sum (Above) and click OK. the value in row 3 should be 4. |
#6
|
|||
|
|||
Table ... and answering your real question
-----Original Message----- I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong? -- Derick in Essex UK Sorry just read your original question again. Are you using ordinary text & fonts (not graphics or symbols) in the cells you're trying to sum up? For example, if the font is a symbol font or something like Wingdings, Webdings or Monotype Sorts, a character might look like a number but actually be another character entirely, like a, x or %. |
#7
|
|||
|
|||
Table ... and answering your real question
Kathleen, thanks for the reply. Unfortunately, I've even tried creating a 'test' table of only a few rows and columns with all set to Times New Roman. Still get the same error message
-- Derick in Essex UK "Kathleen" wrote: -----Original Message----- I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong? -- Derick in Essex UK Sorry just read your original question again. Are you using ordinary text & fonts (not graphics or symbols) in the cells you're trying to sum up? For example, if the font is a symbol font or something like Wingdings, Webdings or Monotype Sorts, a character might look like a number but actually be another character entirely, like a, x or %. |
#8
|
|||
|
|||
Table
Hi, Derick. The problem could be that in your computer, the decimal symbol and the list separator are both the same character (for example, a comma), in which case Word cannot successfully parse an expression. For example, Word cannot determine whether "100,2" represents 100.2 or 100 and 2. To work around this problem, change the list separator under the regional options to a semicolon. To do this, follow these steps:
1. Click Start, point to Settings, and then click Control Panel. 2. Double-click the Regional Settings icon (Microsoft Windows NT or Microsoft Windows 98) or the Regional Options icon (Microsoft Windows 2000). 3. On the Numbers tab (Windows NT) or the Number tab (Windows 2000 or Windows 98) in the List separator box, type a semicolon ( and then click OK. "Derick Chapman" wrote: I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong? -- Derick in Essex UK " wrote: Excel is better if you're doing complicated calculations, but Word is easy & quick to use for doing simple totals, e.g., Sum(Above). -----Original Message----- Hello everyone. I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel?? Thanks for the help. . |
#9
|
|||
|
|||
Table
Thanks for the suggestion 'garfield-n-odie'. I've amended as suggested, but still get the same error message! I'm using "." for decimal, "," to break thousands and now ";" as the list separator. Any other ideas?
-- Derick in Essex UK "garfield-n-odie" wrote: Hi, Derick. The problem could be that in your computer, the decimal symbol and the list separator are both the same character (for example, a comma), in which case Word cannot successfully parse an expression. For example, Word cannot determine whether "100,2" represents 100.2 or 100 and 2. To work around this problem, change the list separator under the regional options to a semicolon. To do this, follow these steps: 1. Click Start, point to Settings, and then click Control Panel. 2. Double-click the Regional Settings icon (Microsoft Windows NT or Microsoft Windows 98) or the Regional Options icon (Microsoft Windows 2000). 3. On the Numbers tab (Windows NT) or the Number tab (Windows 2000 or Windows 98) in the List separator box, type a semicolon ( and then click OK. "Derick Chapman" wrote: I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong? -- Derick in Essex UK " wrote: Excel is better if you're doing complicated calculations, but Word is easy & quick to use for doing simple totals, e.g., Sum(Above). -----Original Message----- Hello everyone. I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel?? Thanks for the help. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Error Message | Di | New Users | 2 | June 30th, 2004 07:57 AM |
Table Analyser and more... | Mary Ann | Database Design | 2 | June 29th, 2004 06:36 PM |
resize table from A4 size to A5 | ims | New Users | 3 | June 9th, 2004 01:05 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Table design for a booking system | Brian C | Database Design | 2 | April 27th, 2004 03:11 AM |