Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why do my dates change to american when I mailmerge?
I have an excel database that contains a formula which minuses seven days off
of a date to create a new date (ie a1-7). I then need to use this new date as part of a letter in Word as a part of a mailmerge. All my computer settings are in English United Kingdom etc. However, when this field merges it automatically changes to the american format (ie 1/23/07 instead of 23/1/07). In excel this date reads correctly and is formatted properly. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change page setup from metric to american standard | Page Layout | |||
microsoft word on american envelope settings how do i change? | Microsoft Word Help | |||
Use find and replace to change American word to Canadian spelling | Microsoft Word Help | |||
How do I change my spell check to Australian English not American. | Microsoft Word Help | |||
Word Mailmerge reading UK dates in Access as US dates | Mailmerge |