Thread
:
How stop Excel file UK date order changing to US order in m.merge
View Single Post
#
2
Posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
Posts: 8,651
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 With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]