Formatting Issue on Number Field

[Brig]

Using Office XP, we have a database from Access & the mail merge document on
Word.

In Access there is a field in number format with 2 decimal points.

However, when the field gets merged in word, we lost the formatting and
sword sometimes put only 1 decimal point or no decimal point at all if its a
whole number.

Is there a way to format the field in Word to show 2 decimal points?

Please note that we are not formating the number to show as currency.

Thank you.

 

[Peter Jamieson]

Try using a numeric switch in your Word merge field, e.g. instead of

{ MERGEFIELD mynumber }

try

{ MERGEFIELD mynumber \##.00 }

Peter Jamieson

 

[Brig]

I'll give it a shot.

Thank you very much.

Brig