Word XP Merge Problem - Number Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trinity579 - 27 Jan 2004 22:23 GMT

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

------------------------------------------------

Reply to this Message

Peter Jamieson - 28 Jan 2004 10:06 GMT

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" }

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I seem to have a strange formating problem.
>
[quoted text clipped - 10 lines]
>
> ------------------------------------------------

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 28 Jan 2004 11:48 GMT

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

Signature

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

>
> I seem to have a strange formating problem.
[quoted text clipped - 11 lines]
>
> ------------------------------------------------

Reply to this Message