Mail Merging Dates HELP PLEASE !!!!!!!!!!!!!!!!!!!!!!

[Beninjam91]

Hello, im in a pickle...

I have to mail merge a data caption form which includes dates (cant say more
data protection act etc). in the excel spreadsheet the dates are formatted in
english (dd/mm/yyyy) but when i merge to a new document Word changes the
dates to mm/dd/yyyy which is a problem for people who are born on the 1st of
July 1979 for example because it shows it as 07/01/79 not 01/07/79 so it
looks like the information is wrong to anyone reading it. HOW DO I CHANGE THE
DATE FORMAT??????????

ive been on microsft help and got diddly sqwat to show from 4 hours of
research....

can anyone help PLEASE!!!!!!!!!!!!!!!!!!!

 

[Daiya Mitchell]

If you aren't using a Mac, you should repost your question, starting
from here (this is a MacWord group):
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

If you are using a Mac, what version of Office? Is this a letter merge?
Before you execute the merge, select all and go to Tools | Language and
make sure English UK is selected.

You might try reformatting the dates in Excel to be something like 22
July 2008, instead of numeric, and thus avoid all possibility of confusion.

 

[macropod]

Answered in microsoft.public.word.mailmerge.fields

Please don't post the same question separately in multiple NGs.

 

[John McGhie]

Well!!! There's a voice from the past!

Hi, long time no see

Answered in microsoft.public.word.mailmerge.fields

Please don't post the same question separately in multiple NGs.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]

 

[macropod]

Hi John,

Where U been? I've posted > 200 responses to MS Office/Word/Excel NG queries so far this month alone ...
Admittedly, only a few have been in the mac-specific NGs.

 

[John McGhie]

Hi Macropod:

Yeah yeah yeah...

I mainly do Mac Word these days. Doing WinWord involves starting Vista, and
I hate it so much I won't fire it up unless I have to

Cheers

Hi John,

Where U been? I've posted > 200 responses to MS Office/Word/Excel NG queries
so far this month alone ...
Admittedly, only a few have been in the mac-specific NGs.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]

 

[macropod]

And you folk do such a good job with the Mac stuff, anyway, and I can never remember which keys equate to Ctrl and Alt. Plus all
those little things like no right-clicks with the mouse, etc.

 

[John McGhie]

Neither can I... If you read for the same part of the keyboard, you usually
get the right one!

Microsoft Office in the later versions is as right-click-centric as PC
Office is. Everything useful is on the right click.

And I think nearly all people who really use Macs in anger use them with a
scroll-wheel mouse Any USB mouse will do, but Microsoft mice go rather
nicely and they tend to "just work" without requiring a driver

Cheers

And you folk do such a good job with the Mac stuff, anyway, and I can never
remember which keys equate to Ctrl and Alt. Plus all
those little things like no right-clicks with the mouse, etc.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]