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
