Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I maintain Excel's number formatting when merging to Word?
I have data in Excel that is set to automatically round to two decimal places
and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#2
|
|||
|
|||
Generally speaking, if you connect to your Excel data using DDE, Word will
retain more of the formatting info. in the Excel sheet - to do that in Word 2002/2003, check Word Tools|Options|General|"Confirm conversion at open" and go through the process of connecting to your data source again. You must have Excel to do this. Peter Jamieson "jenniferb" wrote in message news I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#3
|
|||
|
|||
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 "jenniferb" wrote in message news I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I maintain Excel's number formatting when merging to W
Does anyone know how to replicate this is Word 2007 yet?
"Doug Robbins" 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 "jenniferb" wrote in message news I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I maintain Excel's number formatting when merging to W
In exactly the same way. Alt+F9 to display the field codes and add the
appropriate formatting switch. -- 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 "Heidi" wrote in message ... Does anyone know how to replicate this is Word 2007 yet? "Doug Robbins" 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 "jenniferb" wrote in message news I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I maintain Excel's number formatting when merging to W
The switches on that page should work equally well in 2007?
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Heidi wrote: Does anyone know how to replicate this is Word 2007 yet? "Doug Robbins" 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 "jenniferb" wrote in message news I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I maintain Excel's number formatting when merging to Word?
When working in Excel 2007 you do need to 'protect' the spreadsheet before
you use it for a data source. In Excel, click on the 'Review' tab, and then click on 'Protect Sheet'. Click on 'Format Cells' and then click 'OK' without entering a password (unless it is needed). You should now be able to merge your information without difficulty. This is the same process you would need to go through to have a date from the Excel data base merge into a Word document in the desired format. Excel's default is 04/30/08. Generally, in a letter you want the date to appear as: April 30, 2008. By following the above steps to protect the Excel document the merge will complete correctly. Just remember to unprotect the spreadsheet if you need to make any changes to it. -- Roxanne Still Learning "jenniferb" wrote: I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How can I maintain Excel's number formatting when merging to Word?
Sorry, Roxanne, but that is one thing that you need to un-learn!
It is not necessary for an Excel spreadsheet to be protected for it to be able to be used as a mailmerge data source. If you want to maintain formatting in the way that Jenniferb was after, you add a formatting switch to the mergefield in 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 "Roxanne" wrote in message ... When working in Excel 2007 you do need to 'protect' the spreadsheet before you use it for a data source. In Excel, click on the 'Review' tab, and then click on 'Protect Sheet'. Click on 'Format Cells' and then click 'OK' without entering a password (unless it is needed). You should now be able to merge your information without difficulty. This is the same process you would need to go through to have a date from the Excel data base merge into a Word document in the desired format. Excel's default is 04/30/08. Generally, in a letter you want the date to appear as: April 30, 2008. By following the above steps to protect the Excel document the merge will complete correctly. Just remember to unprotect the spreadsheet if you need to make any changes to it. -- Roxanne Still Learning "jenniferb" wrote: I have data in Excel that is set to automatically round to two decimal places and maintain currency formatting, but when I merge it into Word, that formatting is lost. Is there a way that this number formatting can be maintained when merged to Word? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loss of phone number formatting when merged | Mailmerge | |||
table of contents and page number formatting | Microsoft Word Help | |||
How do I maintain number formatting in a mail merge? | Mailmerge | |||
Maximum number of pages in a word document | Formatting Long Documents | |||
Formatting Issue on Number Field | Mailmerge |