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.
.