Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formatting a Text Form Field
Hi
I have a table (3 rows). rows 1 and 2 contain a Text form field, both of which are Type = Number. I then have, in row 3, a calculated field. (Formula = A1/A2). I need to show the result a a percentage to 4 decimal places. I am completely stuck. ( Can anyone help please? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Formatting a Text Form Field
Hi Duncan,
You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }') and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result. -- Cheers macropod [MVP - Microsoft Word] "Duncan" wrote in message ... Hi I have a table (3 rows). rows 1 and 2 contain a Text form field, both of which are Type = Number. I then have, in row 3, a calculated field. (Formula = A1/A2). I need to show the result a a percentage to 4 decimal places. I am completely stuck. ( Can anyone help please? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Formatting a Text Form Field
Hi Macropod
That is great, thank you.........however (there is always a however isn't there!!) How do I get around deviding by zero? At present I get the following "!Zero Divide" "macropod" wrote: Hi Duncan, You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }') and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result. -- Cheers macropod [MVP - Microsoft Word] "Duncan" wrote in message ... Hi I have a table (3 rows). rows 1 and 2 contain a Text form field, both of which are Type = Number. I then have, in row 3, a calculated field. (Formula = A1/A2). I need to show the result a a percentage to 4 decimal places. I am completely stuck. ( Can anyone help please? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Formatting a Text Form Field
You can error trap the warning message with a conditional field eg
{IF {=A1/A2} "!Z*" "{=A1/A2*100 \# 0.0000%}" "0.0000%"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Duncan wrote: Hi Macropod That is great, thank you.........however (there is always a however isn't there!!) How do I get around deviding by zero? At present I get the following "!Zero Divide" "macropod" wrote: Hi Duncan, You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }') and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result. -- Cheers macropod [MVP - Microsoft Word] "Duncan" wrote in message ... Hi I have a table (3 rows). rows 1 and 2 contain a Text form field, both of which are Type = Number. I then have, in row 3, a calculated field. (Formula = A1/A2). I need to show the result a a percentage to 4 decimal places. I am completely stuck. ( Can anyone help please? |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Formatting a Text Form Field
Hi Duncan.
Basically, the same as you would in Excel: {=IF(A2=0,0,A1/A2*100) \# 0.0000%} -- Cheers macropod [MVP - Microsoft Word] "Duncan" wrote in message ... Hi Macropod That is great, thank you.........however (there is always a however isn't there!!) How do I get around deviding by zero? At present I get the following "!Zero Divide" "macropod" wrote: Hi Duncan, You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }') and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result. -- Cheers macropod [MVP - Microsoft Word] "Duncan" wrote in message ... Hi I have a table (3 rows). rows 1 and 2 contain a Text form field, both of which are Type = Number. I then have, in row 3, a calculated field. (Formula = A1/A2). I need to show the result a a percentage to 4 decimal places. I am completely stuck. ( Can anyone help please? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Form Field Formatting | Microsoft Word Help | |||
Formatting Issue in Form Text Field | Microsoft Word Help | |||
Formatting text form field - can I make the text wrap? | Microsoft Word Help | |||
Date formatting in text form field, part II | Microsoft Word Help | |||
Date formatting in text form field | Microsoft Word Help |