If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Preserving date format
Does anyone know how I can preserve my date format (dd/mm/yy) when doing a
mail merge from Excel to Word? I would like to show either dd/mm/yy or 10 February 2010, but it keeps being switched round to American format (mm/dd/yy). Thanks! |
#2
|
|||
|
|||
Preserving date format
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore vbg.) Julia862621 wrote: Does anyone know how I can preserve my date format (dd/mm/yy) when doing a mail merge from Excel to Word? I would like to show either dd/mm/yy or 10 February 2010, but it keeps being switched round to American format (mm/dd/yy). Thanks! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|