Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge from Excel Spreadsheet
I have data in an excel spreadsheet formatted to 2 decimal places
When I merge my word document with data from this excel file- 5.68 becomes 5.6799999999 etc. How do I keep my merge document output in 2 decimal place format?? Thanks- KHope |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge from Excel Spreadsheet
You'll need to apply a number format switch to the merge field. See
http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "KHope" wrote in message ... I have data in an excel spreadsheet formatted to 2 decimal places When I merge my word document with data from this excel file- 5.68 becomes 5.6799999999 etc. How do I keep my merge document output in 2 decimal place format?? Thanks- KHope |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge from Excel spreadsheet | Microsoft Word Help | |||
how do I use an excel spreadsheet for labels with a Mail Merge | Mailmerge | |||
How can I convert an excel spreadsheet to mail merge in word? | Microsoft Word Help | |||
Mail Merge will not allow me to get Excel spreadsheet addresses | Mailmerge | |||
Mail Merge labels from Excel spreadsheet of addresses | Mailmerge |