Word XP Merge Problem - Number Format

[trinity579]

I seem to have a strange formating problem.

I am using Word 2002 / XP and Access 2000. I have successfully created
a mail merge between a letter in word and a single table dataset in
access, the text based fields are all OK, but I have some number fields
(format - double, auto) that do not appear correctly in the word
document.

For example - an entry of 12.12 in the access table, appears as
12.199999999999999 in Word.

Can somebody please help. Many thanks

 

[Peter Jamieson]

If 12.12 is appearing as 12.19999999etc. as you type then my question is
whether the field type in Access is "Currency", rather than, for example,
"Double".

If it is actually appearing as 12.11999999etc. then use Alt-F9 to toggle the
field code view in Word and modify

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#"0.00" }

If it's a currency amount, you may find the following useful:

{ MERGEFIELD mynumber \#"$,0.00" }

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See the following page of fellow MVP Graham Mayor's website at
http://www.gmayor.com/formatting_word_fields.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP