Formatting a Text Form Field

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. :o(
Can anyone help please?

date: Thu, 2 Oct 2008 04:31:01 -0700 author: Duncan

Re: 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 news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
> 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. :o(
> Can anyone help please?

date: Thu, 2 Oct 2008 22:31:35 +1000 author: macropod lid

Re: 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 news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
> > 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. :o(
> > Can anyone help please? 
> 
>

date: Thu, 2 Oct 2008 06:30:06 -0700 author: Duncan

Re: 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
>> news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
>>> 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. :o(
>>> Can anyone help please?

date: Thu, 2 Oct 2008 16:42:34 +0300 author: Graham Mayor

Re: 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 news:5E5B1441-CB38-4001-885A-24682F129719@microsoft.com...
> 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 news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
>> > 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. :o(
>> > Can anyone help please?
>>
>>

date: Fri, 3 Oct 2008 06:59:58 +1000 author: macropod lid