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
"trolley747" wrote in message
...
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?