Formatting Text to Date

[Mindy]

Here are examples of what's in the Date Column imported from another system.

2009/1/4 09:01 AM
2009/12/5 04:34 AM
2009/3/20 09:00 AM
2009/10/29 04:00 AM

Excel sees the above as text and I need to change them to an acceptable Date & Time format that Excel recognizes. I'm guessing that the only thing that could help is VBA but I'm not familiar enough with that.

Anyone out there that can help me?

Thanks.

[NBVC]

Try selecting the column.. go to Data|Text to Column... select Delimited and click Finish.

[JBeaucaire]

1) Select the column of data
2) Select DATA > TEXT TO COLUMNS > Delimited > NEXT > NEXT
3) On Step 3 of 3, look in the Column Data Format section (upper right) and select Date: YMD (or whatever is correct)
4) Click OK

The YMD selection tells Excel how to read the data, then it will convert to your default display settings as Excel Date/Time values.

[Mindy]

Thanks. The Delimited - Date: YMD worked. And, it was SOO easy. You learn something everyday. Thanks again.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)