Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I get a merge field in Word to display only 2 decimal plac
Hi,
I am using word to merge from an excel spreadsheet. In the spreadsheet, I have numbers entered with two decimal points, almost exclusively either 314.01, 313.81 or 309.81. When I merge that field into a word document, if the number is 314.01, it displays in the word document as 314.00999999999999. If the number is either 313.81 or 309.81, the number displays correctly. So far, I have tried format - cell - number - category "number" with the "number of decimal places 2," and also format - cell - number - category "custom" with a bunch of different iterations of ###0.00, to no avail. Can anyone tell me how to correct this error? Thanks, Chris |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I get a merge field in Word to display only 2 decimal plac
Excel stores formatting separate to data and mailmerge in Word only accesses
the data. To reinstate the formatting in a merge document, you must add formatting switches to the merge fields. To see how to do that, take a look at the item "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, originally posted via msnews.microsoft.com "fatgreta" wrote in message ... Hi, I am using word to merge from an excel spreadsheet. In the spreadsheet, I have numbers entered with two decimal points, almost exclusively either 314.01, 313.81 or 309.81. When I merge that field into a word document, if the number is 314.01, it displays in the word document as 314.00999999999999. If the number is either 313.81 or 309.81, the number displays correctly. So far, I have tried format - cell - number - category "number" with the "number of decimal places 2," and also format - cell - number - category "custom" with a bunch of different iterations of ###0.00, to no avail. Can anyone tell me how to correct this error? Thanks, Chris |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge field display error | Mailmerge | |||
Merge Field doesn't display complete number | Mailmerge | |||
numeric pictu formating merge field without rounding decimal digits? | Mailmerge | |||
need to get home phone field to display during mail merge w/Word | Mailmerge | |||
merge field numbering/decimal place problem | Mailmerge |