Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel data into Word gives incorrect amount
Hi!
When I do a merge into Word from data held in an Excel spreadsheet, the amount gets translated from its Excel form of, say, 10.95, into the form of 10.95000000008 in the merged document. I've tried setting the "precision as displayed" option but this hasn't helped. Any ideas anyone please? Thanks! Carmel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel data into Word gives incorrect amount
You can format your data on the Word side by editing the fields that get
numeric values and adding the proper switch and/or formatting mask. For example: To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00). To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm"). To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch. In Word's Help facility look up the topic "Format merged Data" for additional information regarding the formatting of merged fields. -- Kevin Backmann "Carmel R" wrote: Hi! When I do a merge into Word from data held in an Excel spreadsheet, the amount gets translated from its Excel form of, say, 10.95, into the form of 10.95000000008 in the merged document. I've tried setting the "precision as displayed" option but this hasn't helped. Any ideas anyone please? Thanks! Carmel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel data into Word gives incorrect amount
AHA!!!
Thanks Kevin - that's really helpful! Carmel "Kevin B" wrote: You can format your data on the Word side by editing the fields that get numeric values and adding the proper switch and/or formatting mask. For example: To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00). To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm"). To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch. In Word's Help facility look up the topic "Format merged Data" for additional information regarding the formatting of merged fields. -- Kevin Backmann "Carmel R" wrote: Hi! When I do a merge into Word from data held in an Excel spreadsheet, the amount gets translated from its Excel form of, say, 10.95, into the form of 10.95000000008 in the merged document. I've tried setting the "precision as displayed" option but this hasn't helped. Any ideas anyone please? Thanks! Carmel |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel data into Word gives incorrect amount
An alternative on the Excel side is a helper column with a formula such as
=TEXT(A1,"0.00") -- David Biddulph "Kevin B" wrote in message ... You can format your data on the Word side by editing the fields that get numeric values and adding the proper switch and/or formatting mask. For example: To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00). To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm"). To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch. In Word's Help facility look up the topic "Format merged Data" for additional information regarding the formatting of merged fields. "Carmel R" wrote: Hi! When I do a merge into Word from data held in an Excel spreadsheet, the amount gets translated from its Excel form of, say, 10.95, into the form of 10.95000000008 in the merged document. I've tried setting the "precision as displayed" option but this hasn't helped. Any ideas anyone please? Thanks! Carmel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect day displayed when merging data | Excel Discussion (Misc queries) | |||
Fix too few data fields error message when merging excel and word | Excel Discussion (Misc queries) | |||
Merging excel data into word | Excel Discussion (Misc queries) | |||
Merging data from Excel to Word | Excel Worksheet Functions | |||
Merging Excel Data into Word | Excel Discussion (Misc queries) |