MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert general format to date format


Posted by Shirlene on July 26, 2001 8:41 AM

Someone has thousands of cells formatted as general text and typed in numbers like 19980220. They now want all of these cells converted to date format like 02-20-1998. What is the easiest way to do this? Any help is most appreciated. Thanks in advance.


Posted by Shirlene on July 26, 2001 8:44 AM

Ooops!!! My apologies. The general format is NOT text but number.

Posted by Mark W. on July 26, 2001 8:51 AM

Shirlene, use Excel's Data | Text to Columns...
menu command. First, select the values to be
converted. Choose the Text to Columns... command.
Press the [ Next > ] button until you get to
Step 3 of 3. Choose "YMD" date format, and
press [ Finish ]. Finally, apply your desired
date format.

Posted by Shirlene on July 26, 2001 8:59 AM

Thank you, Mark. It worked great!!