Convert number to date

fearless2002uk · Jan 31st 2003

I have a spreadsheet with a column of 3500 numbers (in this format 20030129 or 19971112 for example) they are infact dates - I am struggling to format them as such. HELP!

Many thanks in advance

Epidemic · Jan 31st 2003

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

should work as long as the format remains the same as your example

fearless2002uk · Jan 31st 2003

Thanx i'll suck it and see!

Epidemic · Feb 1st 2003

you will suck it an see???

Was that an insult or friendly statement.:):):)

fearless2002uk · Feb 4th 2003

sorry, a quirky figure of speech meaning 'I'll tryit out'! Incidentally, I have, and it worked. Thanx again.

:lol::lol::lol:

Convert number to date

Participate now!

Share

Users Viewing This Thread