Date Formatting Problem

J

Jocko69

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!
 
R

Roger Govier

Hi

One way
Mark your range of data. Data>Text to Columns>Next>Next>Click Radio button
for choose one of the date formats to suit.
 
R

Ragdyer

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.
 
Top