Excel data to mail merge in word.

[TapasGirl]

Hi, hope someone can help with this.
I am using an Excel spreadsheet as my data file for a Word mail merge letter.

I have a column of salary data which when you look at the column of numbers in Excel it shows pound signs (£) and the relevant decimal point places, e.g. £25,000. When I merge the data sheet into Word the pound sign and decimal places do not appear so it reads 25000 in the letter, which is incorrect.

I have tried formatting to no avail.

Appreciate any help.
thanks

Try just having it as general format in excel, and the inserting the £ sign before your merge field in your word doc

In Word, press ALT+F9 to view the field codes; it should look something like:

{ MERGEFIELD "salary" }

Add a format switch so it looks like this:

{ MERGEFIELD "salary" # £#,###.00 }

Actually, if you don't want the pence use:

{ MERGEFIELD "salary" # £#,### }