Convert text of dates (non-Excel format) to dates 1

[Latexman]

From another program, I get text of dates like Jan-03-2004, May-11-2006, and Apr-22-1988. I didn't see this format in Excel, so I can't use DATEVALUE. How do I convert these into something useful, i.e. to an Excel date format?

Good luck,
Latexman

 

[yogia]

From another program, I get text of dates like Jan-03-2004, May-11-2006, and Apr-22-1988. I didn't see this format in Excel, so I can't use DATEVALUE. How do I convert these into something useful, i.e. to an Excel date format?

Hi Latexman:

You can use Data|Text_to_columns to convert your entries into EXCEL acceptable formats by using the following steps ...

1) select your range of entries that you want to convert
2) invoke data|Text_to_columns
3) click next, next, and you will be on Step 3 of 3
4) in the Column_Data_format box select the option Date, and in the DropDownBox select MDY
5) click enter to convert the entries into dates in-place or select another location to plant the dates using the Desination_box.

I hope this helps.


Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC

http://www.energyefficientbuild.com

 

[Latexman]

Sweet! Thanks Yogi!

Good luck,
Latexman