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
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
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
should work as long as the format remains the same as your example
Thanx i'll suck it and see!
you will suck it an see???
Was that an insult or friendly statement.:):):)
sorry, a quirky figure of speech meaning 'I'll tryit out'! Incidentally, I have, and it worked. Thanx again.
:lol::lol::lol:
Don’t have an account yet? Register yourself now and be a part of our community!