Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How stop Excel file UK date order changing to US order in m.merge
I have DOB field in an Excel file in deliberate UK order (eg. 23/05/2000)
which I want to put onto labels. I go through the mail merge wizard but when i call up the file and look at it, the DOB has changed to US order (eg. 05/23/2000) and this then appears on the labels. Using 2003 Office. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How stop Excel file UK date order changing to US order in m.merge
If you use =TEXT(A1,"dd/mm/yyyy"), the mail merge won't reformat the
resulting text string. I'm a little surprised that you've seen the field as 05/23/2000, as I would have thought it more likely that it would see 36669. -- David Biddulph "Roger Aldridge" <Roger wrote in message ... I have DOB field in an Excel file in deliberate UK order (eg. 23/05/2000) which I want to put onto labels. I go through the mail merge wizard but when i call up the file and look at it, the DOB has changed to US order (eg. 05/23/2000) and this then appears on the labels. Using 2003 Office. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Stop Order | Excel Discussion (Misc queries) | |||
Tab Stop Order | Excel Discussion (Misc queries) | |||
changing folder order in File Save | Excel Discussion (Misc queries) | |||
Merge text in sequential order | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |