98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2003
James has attended:
Excel Advanced course
Excel
I am mail merging from an excel spreadsheet into a word document and the currency format from the original spreadsheet is lost when the merge happens. Any ideas how I can either carry the format across when merging or apply the currency formatting in Word.
RE: Excel
Hello James
Thank you for your question.
This you will need to fix from in Word rather than Excel.
Assuming the field you are inserting the figures across from has a heading Amount in Excel:
Once you have inserted the field Amount into the Word document, right-click in the Amount field in Word and select Toggle Field Codes. You should now see {MERGEFIELD Amount}.
After Amount (or the name of your field where the numbers are coming from in the spreadsheet) type in the following:
\# "
RE: Excel
Thanks Amanda, that works well. I was also told another solution that might interest you. In Word select TOOLS, OPTIONS, GENERAL and then tick 'Confirm Conversion at Open'. Then, when selecting your data source for merging, you will get a box called 'Confirm Data Source' and you now select 'MS Excel Worksheets via DDE (*.xls)'
Cheers
James
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |