Numbers/spreadsheet import question
Ok, here is my problem:
I have a csv file containing a column of dates in the format 20070723 but I can't get numbers to recognize this as a date. I also tried to open the same file in excel but have the same problem here. Probably i am just missing something... Anybody have a suggestion?
Edit, OK, I managed to convert it using the excel-tip I found here, but seems like numbers should be able to handle something simple as this - no?
I have a csv file containing a column of dates in the format 20070723 but I can't get numbers to recognize this as a date. I also tried to open the same file in excel but have the same problem here. Probably i am just missing something... Anybody have a suggestion?
Edit, OK, I managed to convert it using the excel-tip I found here, but seems like numbers should be able to handle something simple as this - no?
Comments