mailmerge date field opens as date serial number

[Joe Perniciaro]

I've used switches and check the format in excel. Can't isolate the cause. I have more than one date field in the document and some open ok and others don't.

I'm using word and excel 2003.

Any suggestions?

Thanks

Joe

 

[Peter Jamieson]

It's probably because you have mixed data types in the Excel column that the
problem occurs with - see

http://tips.pjmsn.me.uk/t0003.htm

for further info.

--
Peter Jamieson
http://tips.pjmsn.me.uk

in message
news:[email protected]...