Change date format in Excel

May 2, 2012 at 09:02:52
Specs: Windows 7
I need to change a date format from 20120105 to 05Jan2012 in Excel. Thanks.

See More: Change date format in Excel

Report •


#1
May 2, 2012 at 10:07:10
First, before you do anything, make sure it is a real DATE,
not a TEXT string that looks like a Date.

To check, select your cell with the date
Right Click your mouse and select Format Cells
Select the Number TAB
Select General

You should have a 5 digit number, if you do not, then you do not have a real DATE, you have a TEXT string that looks like a Date.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question