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