| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculations involving euros
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. -- Cheers macropod [Microsoft MVP - Word] "Lenny" wrote in message ... 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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculations | Tables | |||
| Digital Signature Glitch involving unviewable text | Microsoft Word Help | |||
| Toggle form field between U.S. dollars and Euros | Microsoft Word Help | |||
| Runtime error involving "scoring.cpp" since Office SP2 update? | Microsoft Word Help | |||
| Can i make the euros sign | Microsoft Word Help | |||
Linear Mode
