Using Excel for Mailmerge - coming in at 6 decimal points?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trolley747 - 26 Jul 2007 20:14 GMT

I am trying to use an excel spreadsheet to do a mail merge for hourly rates
of pay. I am using for example a rate of £5.84. When this merges into word it
is showing as 5.83999999. The cells in excel are formatted correctly and i
have tried it with text and number cells but still doesnt work?

Reply to this Message

Doug Robbins - Word MVP - 27 Jul 2007 07:42 GMT

The formatting of cells in Excel only controls the way in which Excel
displays the data, not the way in which it is stored.

To learn how to control the way in which data is presented when mail merged
into Word, See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to use an excel spreadsheet to do a mail merge for hourly rates
> of pay. I am using for example a rate of £5.84. When this merges into word
> it
> is showing as 5.83999999. The cells in excel are formatted correctly and i
> have tried it with text and number cells but still doesnt work?

Reply to this Message

Rate this thread: