Star79
asked on
Excel File Date Format
I have an excel file which has data for a date column '23-SEP-15'
How to format this to 09/23/2015
How to format this to 09/23/2015
Press ctrl+1 to go to cell formatting. Select "Date" for the category and the format should be the first in the list.
No, I take that back. In my case, it's the 5th option "03/14/01". The first option will truncate off the first "0" in the month.
ASKER
Its not working for me.Book1 is attached.
Book1.xlsx
Book1.xlsx
Weird.
I was able to fix it by going into the cell, then hitting F2 and Enter.
I was able to fix it by going into the cell, then hitting F2 and Enter.
ASKER
can you post back that file where you fixed it please
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.