my decimals don't work with this

[sherry]

I also have a decimal format problem word2000.
If I formaat it as \# "0.00" my number gets rounded up,
(29.00)
If I don't format at all it drops the ending 0.(28.1)
My source is a vfp8 table, field is numeric 8 with 2 dec.

 

[macropod]

Hi Sherry,

I'm unable to replicate the rounding up in Word 2000, using {=28.10 \#
0.00}, or {=28.10 \# "0.00"}. Both return '28.10'

Even {=28.10 \# 0} rounds to the nearest whole number('28'), not
specifically up/down, while {=28.10} returns '28.1'

Perhaps if you post more details about your source data and how it's
imported a solution can be found.

Cheers