Convert Numbers to Date

[Legacy 137396]

Good day all!

Question!>

How can I convert / insert text into a cell to have it changed into a date?

I downloaded a calender from a website in excel format. bu the dates are all
"YYYYMMDD" eg. 20100114

How can I either insert an dash " - " inbetween them all or convert them into a date?

Would really be helpfull. I got 600+ rows with events on this calander.

Thnaks in advance!

P.s its currently in the cell with the cell format as "General"

 

[Jonmo1]

Welcome to the board...

Try

Data - Text to columns
Deliminated - Next
Next
Under "Column Data Format", Select Date - YMD
Finish

Hope that helps..

 

[Domski]

Or as a formula:

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

Dom

 

[Legacy 137396]

Welcome to the board...

Try

Data - Text to columns
Deliminated - Next
Next
Under "Column Data Format", Select Date - YMD
Finish

Hope that helps..

OK your solution works some how.. but I think I'm doing it wrong..
Or its because the text in the cell doesn't have a delimiter (my cell has no dashes in it)

the contents of my cells are just plain
" 20090928 "
in such a format that its >> YYYYMMDD

 

[Legacy 137396]

Or as a formula:

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

Dom

I think thats a little to advanced for me :S I have no idea what you meant or how to do it

 

[Jonmo1]

OK your solution works some how.. but I think I'm doing it wrong..
Or its because the text in the cell doesn't have a delimiter (my cell has no dashes in it)

I'm not exactly sure HOW it works either, I just know it does.

I think it's like, people haveing dates in that format are pretty common, so MS put in some programming to recoginize it and convert it.