Formatting a Text Form Field

[Duncan]

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?

 

[macropod]

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.

 

[Duncan]

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"

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]

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?

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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"

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]

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?

 

[macropod]

Hi Duncan.

Basically, the same as you would in Excel:
{=IF(A2=0,0,A1/A2*100) \# 0.0000%}

--
Cheers
macropod
[MVP - Microsoft Word]

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"

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]

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?