Link to home
Start Free TrialLog in
Avatar of Star79
Star79Flag for United States of America

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
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

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.
Avatar of Star79

ASKER

Its not working for me.Book1 is attached.
Book1.xlsx
Weird.

I was able to fix it by going into the cell, then hitting F2 and Enter.
Avatar of Star79

ASKER

can you post back that file where you fixed it please
ASKER CERTIFIED SOLUTION
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial