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