Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date - not working for me
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 \@ "MM/dd/yy" } -- Thanks, Pat |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date - not working for me
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 \@ "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" \@ "M/d/YY"} however it did not change the format at all. What am I missing? Thank you. Pat. -- Thanks, Pat "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 \@ "MM/dd/yy" } -- Thanks, Pat |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date - not working for me
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 \@ "MM/dd/yy" } |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Date - not working for me
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: 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 \@ "MM/dd/yy" } |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Date Not Working - Please Help!! | Microsoft Word Help | |||
Autocomplete on date is no longer working | Microsoft Word Help | |||
Auto Compete Date not working | Microsoft Word Help | |||
long date formatting in access shows as short date in word | Mailmerge | |||
Date Format Not Working | Mailmerge |