Previous Topic Next Topic

Excel: Chnge Gen # format to date format.

Closed
Brian - Nov 1, 2011 at 10:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 1, 2011 at 10:51 AM
Hello, I have searched this site but can't see how to get an Excel colume I have to convert to a date format. The column has dates in this general number format:

Oct 21, 2011

and I would like to change the format to a dd-mmm-yy date format so I can sort by date.

Any help greatly appreciated.

Brian in Vancouver Canada.



Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 1, 2011 at 10:51 AM
Hi Brian,

Select your cell(s) and hit Ctrl+1 or right click properties.
Goto number tab and select the botom option.
Now you can enter any format you like.

Best regards,
Trowa

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses