date format in Excel
07 February 2005, 10:25 AM
#1
Scooby Regular
Thread Starter
Join Date: Dec 2002
Location: Sunny BELFAST
Posts: 19,408
Likes: 0
Received 0 Likes
on
0 Posts
date format in Excel
I have an excel spreadsheet that i use as an ODBC source from which i run a mail merge. the letter in word extracts a date from the xls sheet but in the actual mail merge document the date format does not cross over to the word document and instead of following the dd/mm/yyyy format in the xls sheet the word document produces yy/mm/dd:hr.min.sec
regional settings are UK English
Anyone give me a solution of point me in the right direction of an faq.
i am running xp pro with office 2003.
cheers
sinky
regional settings are UK English
Anyone give me a solution of point me in the right direction of an faq.
i am running xp pro with office 2003.
cheers
sinky
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM