View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Mail Merge issue

What happens if you type in 5.5 preceded by an apostrophe '

Also you might be better off posting an a Word newsgroup since mailmerge is
done in Word

http://word.mvps.org/FAQs/MailMerge/index.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"b_walls1" wrote in
message ...

I am using a word document to mail merge data from an excel spreadsheet.
When i merge figures they appear perfect in the word doc if they are
rounded, but if they are not rounded they appear with loads of figures
after them for example if i place 5.5 in cell it will appear fine in
the word doc but if i put 5.6 it would appear 5.5999999999999996 i
would really appreciate any help. i have tried formatting it into
different types text number s etc but no luck, i don't know where the
error is?


--
b_walls1
------------------------------------------------------------------------
b_walls1's Profile:
http://www.excelforum.com/member.php...o&userid=33090
View this thread: http://www.excelforum.com/showthread...hreadid=528997