Word mail merge with Excel - unable to reduce decimal places

[LSQUARE]

I am doing a mail merge using Word & Excel 2003.

The fields are correctly merging onto the Word document.

However, there is a problem with the numeric fields on the Word document. I would like to round the numeric field to 2 decimal places on the Word document. When I view the Excel fields using the mail merge feature in Word (Edit recipient list), the source data in numeric fields do show more than 2 decimal fields to the left.

So the problem appears to be in Excel. I have formatted the numeric field columns in Excel to 2 decimal places, but this does not solve the problem. The data in the Excel file was imported via ODBC to our Accounting program database.

Any suggestions would be helpful

 

[cheerio]

You control the formatting in Word not Excel.

For example if I have a field in Excel with Age (eg values like 19.6)

then in Word I can view field codes and add a format string \# # like this:

{MERGEFIELD age \# #}

to show whole numbers.

Here the \# tells Word I want to define a number format, as distinct from a date say, and the second # is the format itself and will display to the nearest whole number.

 

[LSQUARE]

Thanks Cheerio

Very helpful.