Hi andrew
try the following formula in an adjacent column
=DATEVALUE(A1)
and copy down
after this copy this helper column and insert it again as 'Values' with
Edit - Paste Special

--
Regards
Frank Kabel
Frankfurt, Germany

"Andrew" schrieb im Newsbeitrag
...
Ladies & Gents,

I was wondering if someone could help me out with a little problem.
I have
an Excel spreadsheet which contains a column with date values as
Text. I
want to convert them to a Date format of "dd/mm/yyyy". Normally I
would
highlight the column, then go Data, Text to Columns, select the
entire
column as a Fixed width, then select the desired format. The problem
is
that some of the dates are 8 characters long, and some are 7
characters
long. How can I write a formula or function for this spreadsheet
which will
convert 7 & 8 character text into an 8 character date?


Thanks in advance
Andrew