Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Currency format is lost during Document Merge from Excel to Word.
Currency format is lost during Document Merge from Excel to Word. Why?
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Currency format is lost during Document Merge from Excel to Word.
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 "cloparo" wrote in message ... Currency format is lost during Document Merge from Excel to Word. Why? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Currency format is lost during Document Merge from Excel to Word.
It's because the way Word gets data by default from Excel (OLEDB) looks at
the "underlying data" in Excel, not the "presentation" version of the data. If you have Excel, you can revert to the old connection method (DDE) by checking Word Tools|Options|General|"Confirm conversions at open", reconnecting to the Excel sheet and selecting the DDE option when it is offered. Alternatively, you may be able to format currency amounts by changing the field code from e.g. { MERGEFIELD mynumber \*mergeformat } to e.g. { MERGEFIELD mynumber \#"$,0.00" } I don't like it either, but that's the way it is. This explanation and approach to a solution has been posted hundreds if not thousands of times in this group, yet you do not appear to have looked for it. Why? Peter Jamieson "cloparo" wrote in message ... Currency format is lost during Document Merge from Excel to Word. Why? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Currency format is lost during Document Merge from Excel to Wo
Thanks, Peter.
I just upgraded our PCs recently and this is the first time it has happened. That's why I didn't ask before - didn't know the problem existed until now! I will try your suggestions. Carmen "Peter Jamieson" wrote: It's because the way Word gets data by default from Excel (OLEDB) looks at the "underlying data" in Excel, not the "presentation" version of the data. If you have Excel, you can revert to the old connection method (DDE) by checking Word Tools|Options|General|"Confirm conversions at open", reconnecting to the Excel sheet and selecting the DDE option when it is offered. Alternatively, you may be able to format currency amounts by changing the field code from e.g. { MERGEFIELD mynumber \*mergeformat } to e.g. { MERGEFIELD mynumber \#"$,0.00" } I don't like it either, but that's the way it is. This explanation and approach to a solution has been posted hundreds if not thousands of times in this group, yet you do not appear to have looked for it. Why? Peter Jamieson "cloparo" wrote in message ... Currency format is lost during Document Merge from Excel to Word. Why? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Currency format is lost during Document Merge from Excel to Wo
Thanks, Doug.
Carmen "Doug Robbins - Word MVP" wrote: 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 "cloparo" wrote in message ... Currency format is lost during Document Merge from Excel to Word. Why? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Word & WordPerfect | Microsoft Word Help | |||
WP merge file to Word | Tables |