Calculations involving euros

[Lenny]

I have a table in a protected form template that should produce calculations
where:
Example:
Col A x Col B = Col C
3 10 000,00 € 30 000,00 €

Should the form fields in Col's A and B be other than Formtext (Text)?
Should either or both be formatted as 'Number' with a display of: # ##0,00
€;(# ##0,00 €)

Currently my formula in col c is: {=A1*B1 \# ##0,00 €;(#,##0,00 €);"} which
is producing the following result: 030 € and not 30 000,00 € as it should.
What am I not understanding? Assistance in getting this sorted out is
greatly appreciated.

Lenny

 

[macropod]

Hi Lenny,

AFAIK, you can't have a space as a separator in a number used in a calculation by a Word field. You would need a macro to
re-interpret the field's contents, then output the calculation to the target cell/field.