Problem when merging from excel to word

Amd / AMD
April 29, 2009 at 23:15:51
Specs: Windows Vista, 512MB
Hi, when merging from excel to word, the format of date gets mixed . i.e. in the excel sheet the day is dd/mm/yy and when merging to word it changes to mm/dd/yy...
any help?
10x

See More: Problem when merging from excel to word

Report •


#1
April 30, 2009 at 06:36:49
In Word, try, on the Task Bar, Insert, Date and Time, it should offer you a small menu of different formats.
Pick the one you like and press the Default button at the bottom.

MIKE

http://www.skeptic.com/


Report •

#2
April 30, 2009 at 10:04:11
I don't think my first try is going to work. :-(

You are going to have to customize your merge fields in Word.

Go here, everything you always wanted to know about Word fields:

http://www.gmayor.com/formatting_wo...

The date fields are near the bottom.

It is very similar to creating a Custom Format in Excel.

For your purposes something like:

{ DATE \@ "dd/MM/yy" }

should do it.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question