Formatting Date - not working for me Pat 12/22/2008 10:08:01 PM Hello, I am pulling in a date from Excel and it is formatting as a number. I have searched and see the example of { Mergefield Birthday \[ at ] "MM/dd/yy" } -- Thanks, Pat

RE: Formatting Date - not working for me Pat 12/22/2008 10:18:11 PM Sorry about that last message. It posted to early. Please let me finish my qeustions. I am pulling in a date from Excel and it is formatting as a number. I have searched and see the example of { Mergefield Birthday \[ at ] "MM/dd/yy" } However when I enter this into the field it does not change the format. Right now it's coming in as 39556 THis is what I have entered: {MERGEFIELD "my field name" \[ at ] "M/d/YY"} however it did not change the format at all. What am I missing? Thank you. Pat. -- Thanks, Pat "Pat" wrote: [Quoted Text] > Hello, > > I am pulling in a date from Excel and it is formatting as a number. > I have searched and see the example of > { Mergefield Birthday \[ at ] "MM/dd/yy" } > > -- > Thanks, Pat

Re: Formatting Date - not working for me Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 12/22/2008 10:22:31 PM See http://tips.pjmsn.me.uk/t0003.htm Peter Jamieson http://tips.pjmsn.me.uk Pat wrote: [Quoted Text] > Hello, > > I am pulling in a date from Excel and it is formatting as a number. > I have searched and see the example of > { Mergefield Birthday \[ at ] "MM/dd/yy" } >

Re: Formatting Date - not working for me Pat 12/22/2008 10:45:01 PM Thank you! I used #2 - and changed the way word gets the data. Seems to have worked for a few of the issues I was running into. have a great evening. -- Thanks, Pat "Peter Jamieson" wrote: [Quoted Text] > See http://tips.pjmsn.me.uk/t0003.htm > > > > Peter Jamieson > > http://tips.pjmsn.me.uk > > Pat wrote: > > Hello, > > > > I am pulling in a date from Excel and it is formatting as a number. > > I have searched and see the example of > > { Mergefield Birthday \[ at ] "MM/dd/yy" } > > >