Thanks for your help, this works a real treat.

Regards, Nav

"daddylonglegs" wrote:


You could try a formula in another column, e.g. if your dates are in
column A use this in B1 and copy down

=IF(ISTEXT(A1),VALUE(REPLACE(MID(A1,4,3)&A1,7,3,"" )),DATE(YEAR(A1),DAY(A1),MONTH(A1)))

If the "date" is of the form 01/20/05 and excel is treating it as text
it will convert to a date, i.e. 20/01/05 or if it's being treated as a
date but the wrong one - e.g. 10th december becomes 12th October - it
will switch the month and day.

Note: this is designed to work where the days and months are always
shown as two digits e.g. 01 not just 1


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503297