Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date
opening a CSV file into Excel.
I need to convert one column full of dates. I tried the text to columns function.. however it only changes the date with two digits in day ( eg. 13022005 is converted to 13/02/2005) but the dates with single digit day ( eg. 9022005 are not converted to 9/2/2005) any help pls |
#2
|
|||
|
|||
date
May not be the most efficient wany but I would use...
=DATE(RIGHT(A1,4),IF(LEN(A1)=8,MID(A1,3,2),MID(A1, 2,2)),IF(LEN(A1)=8,LEFT(A1,2),LEFT(A1,1))) (assuming your date string is in cell A1) "flow23" wrote: opening a CSV file into Excel. I need to convert one column full of dates. I tried the text to columns function.. however it only changes the date with two digits in day ( eg. 13022005 is converted to 13/02/2005) but the dates with single digit day ( eg. 9022005 are not converted to 9/2/2005) any help pls |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions |