field formatting decimal points

[Greg]

Sheldon,

Do you want 1.98 rounded? You could use \# #.00 to force
two digits after the decimal.

 

[Graham Mayor]

You could use a conditional field to ascertain whether the data was a whole
number and format according to the result of that condition e.g.

{IF{Mergefield Number}= "{=INT({Mergefield Number})}" "{Mergefield Number \#
",#"}" "{Mergefield Number \# "#.0"}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Greg Maxey]

Sheldon/Graham,

I couldn't get Graham's suggestion to work. Problem was it would only work
for a round down.

I played around a bit and came up with following convoluted but workable
field:

{ IF { =OR({ =ROUND({ REF Test },1) }={ =INT({ REF Test }) },{ =ROUND({ REF
Test },1) }={ +INT({ REF Test } + 1) }) = "1" "{ REF Test \# ",0" }" "{ REF
Test \# "0.0)" }" }

--
\\\\///////////
( @ @ )
----oo00---(_)---00oo----
Greg Maxey
A peer in "peer to peer" support
Ewa Beach, HI

 

[Shedlon]

Thanks to Graham and Greg for your responses. They've
given me something to play with, but I'm not sure this is
going to work for me in real life because the number will
be coming into the field using DDEAUTO and constantly
updating.

In fact there could be as many as 20-30 such numbers,
we're talking real-time monitoring of share prices here,
which might just be too much calculating and monitoring
for Word & Windows to handle at a decent speed.

Regards, Sheldon