View Single Post
  #4   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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?