Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Formatting Problem
How can I convert the following date format into something useable that excel can recognize as a vaild date?
Here is the date format I have to work with: Jan-01-05 Jan-02-05 , etc.... Any help would be much appreciated. Thank you! |
#2
|
|||
|
|||
Date Formatting Problem
Hi
One way Mark your range of data. DataText to ColumnsNextNextClick Radio button for choose one of the date formats to suit. -- Regards Roger Govier "Jocko69" wrote in message ... How can I convert the following date format into something useable that excel can recognize as a vaild date? Here is the date format I have to work with: Jan-01-05 Jan-02-05 , etc.... Any help would be much appreciated. Thank you! -- Jocko69 |
#3
|
|||
|
|||
Date Formatting Problem
Actually, you *must* choose
MDY Since that is the format of the present data, otherwise you'll return an incorrect date, or no date at all. After the TTC conversion, you can then custom format to whatever date display you wish. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Roger Govier" wrote in message ... Hi One way Mark your range of data. DataText to ColumnsNextNextClick Radio button for choose one of the date formats to suit. -- Regards Roger Govier "Jocko69" wrote in message ... How can I convert the following date format into something useable that excel can recognize as a vaild date? Here is the date format I have to work with: Jan-01-05 Jan-02-05 , etc.... Any help would be much appreciated. Thank you! -- Jocko69 |
#4
|
|||
|
|||
Date Formatting Problem
Hi RD
Quite right. I sort of glossed over that bit<g -- Regards Roger Govier "Ragdyer" wrote in message ... Actually, you *must* choose MDY Since that is the format of the present data, otherwise you'll return an incorrect date, or no date at all. After the TTC conversion, you can then custom format to whatever date display you wish. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Roger Govier" wrote in message ... Hi One way Mark your range of data. DataText to ColumnsNextNextClick Radio button for choose one of the date formats to suit. -- Regards Roger Govier "Jocko69" wrote in message ... How can I convert the following date format into something useable that excel can recognize as a vaild date? Here is the date format I have to work with: Jan-01-05 Jan-02-05 , etc.... Any help would be much appreciated. Thank you! -- Jocko69 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditioal formatting problem | Excel Discussion (Misc queries) | |||
Date problem using VBA | New Users to Excel | |||
Conditional Formatting Based on Date | Excel Discussion (Misc queries) | |||
Date and time formatting | Excel Discussion (Misc queries) | |||
Incorrect Date formatting | Excel Discussion (Misc queries) |