Date Format Problems PAR 11/1/2008 10:37:00 PM I have several date fields on a merge document, merging from Excel,and have used FieldName \[ at ] "MM-dd-yyyy" but the result is the excel storage format ex = 39098 should be 01-16-2007

RE: Date Format Problems PAR 11/1/2008 10:39:01 PM Forgot to mention I am using Word 2007 "PAR" wrote: [Quoted Text] > I have several date fields on a merge document, merging from Excel,and have > used > FieldName \[ at ] "MM-dd-yyyy" > > but the result is the excel storage format ex = 39098 should be 01-16-2007

Re: Date Format Problems Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 11/1/2008 11:40:59 PM The chances are that you have a mix of cell types in your date column in the first 8 rows of the excel sheet See http://tips.pjmsn.me.uk/t0003.htm -- Peter Jamieson http://tips.pjmsn.me.uk PAR wrote: [Quoted Text] > Forgot to mention I am using Word 2007 > > "PAR" wrote: > >> I have several date fields on a merge document, merging from Excel,and have >> used >> FieldName \[ at ] "MM-dd-yyyy" >> >> but the result is the excel storage format ex = 39098 should be 01-16-2007