Word 2002 - Form - SUM formula Syntax Error

[mokshadavid]

I have a form on a network drive, accessed onsite and off.

I have a simple formula in a table cell that adds the user-entered "text
form fields" cell amounts labeled earned_income_01, earned_income_02, etc...

When we use the form onsite, we have no problems. When offsite staff try to
use the form, accessing the same network drive, the form gives the error
"!Syntax Error, EARNED_IN"

Here is my formula:
{=SUM(earned_income_1,earned_income_2,earned_income_3,earned_income_4,earned_income_5,earned_income_6,earned_income_7,earned_income_8)
\# "$#,##0.00;($#,##0.00)}

This is really confusing because I don't understand how it can work fine for
me and staff onsite, work fine for staff for a little while, then start
having a Syntax Error.

Any ideas?

 

[mokshadavid]

That last part is formatted correctly in my formula, I didn't copy it right
for this post:

The last part does have the parentheses at the end, so that's not the problem.

\# "$#,##0.00;($#,##0.00)"}

 

[mokshadavid]

That first part should read "earned_income_1, earned_income_2" like it is in
the formula below it.

That's not the problem either. :-0

 

[macropod]

Hi mokshadavid,

For the PCs having problems, check their regional settings in the Control Panel to make sure the number and currency formats are
correct.