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

T

trolley747

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?
 
D

Doug Robbins - Word MVP

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top