Hi all,

I have two problems with the format of two different columns of dates i have
coppied onto an excel sheet. I need to be able to have the dates in a
standard date format in order to be able to work with them. The problems are
as follows:

1)The first column of dates are written as numbers with no dividers, eg.
05/10/07 is written as 51007. Is there any easy way to just format this as a
date? Or will i just have to use a formula to convert it?

2)The second column of dates look like they're in date format - eg.
26/10/2007 but dont seem to be in a numerical date format as i am unable to
change the format of how the date is displayed or change it to a number??

any ideas would be much appreciated

thankyou

patrick