View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
Lenny Lenny is offline
external usenet poster
 
Posts: 74
Default Calculations involving euros

I have a table in a protected form template that should produce calculations
whe
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