Date format changed and decimal places change in Word 2003 mail me

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle - 09 Feb 2005 22:41 GMT

I have merged an Excel spreadsheet, and in Word the date format has changed
to mm/dd/yyyy, instead of dd/mm/yyyy (I'm from NZ). Also, in the same merge
document the numbers have changed from one decimal place in the Excel
spreadsheet, to up to 10 decimal places in the Word document.

Can anyone help please?

Reply to this Message

Doug Robbins - 09 Feb 2005 23:47 GMT

We also help New Zealanders here.

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

and "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have merged an Excel spreadsheet, and in Word the date format has changed
> to mm/dd/yyyy, instead of dd/mm/yyyy (I'm from NZ). Also, in the same
[quoted text clipped - 3 lines]
>
> Can anyone help please?

Reply to this Message