Custom Form Field Type?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Sattler - 19 Nov 2007 12:44 GMT

I need to be able to enter and calculate prices which may have 4 decimal
point. The number option only offers limited formatting options. How can
I add the ones I need? Ideally I would like to show 2 decimal places unless
I enter more places manually. Using a macro would also be fine to turn on
the extended decimal places. Thank you for any assistance you can offer.

Jerry

Reply to this Message

Graham Mayor - 19 Nov 2007 15:05 GMT

Using fields to calculate your prices, the number of decimal places
shouldn't matter. The calculation should use the maximum number of places.
Just leave out the switch.

${ ={ REF Text1 } + { Ref Text2 } + { REF Text3 } } = $32.3083
or
If you want the final total to be limited to two decimal places put the
switch at the end of the calculation eg

{ ={ REF Text1 } + { Ref Text2 } + { REF Text3 } \# "$,0.00"} = $32.31

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I need to be able to enter and calculate prices which may have 4
> decimal point. The number option only offers limited formatting
[quoted text clipped - 4 lines]
>
> Jerry

Reply to this Message