View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
Duncan Duncan is offline
external usenet poster
 
Posts: 21
Default 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?