View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge keeps putting in decimals that are not on excel sheet

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

"eazy01" wrote in message
...
mail merge keeps putting in decimals that are not on excel sheet --
example
would be you've got a figure saying £5.37 but instead it brings up
£5.3699999999999 on the preview -- I've tried looking at the figures in
the
spreadsheet and there's nothing wrong with them - I've even tried
formating
the figures in the spreadsheet and that doesn't work.