excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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


 

Excel tip:

Quick Absolute Cell References

When 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).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.09 secs.