How to change the date format in Excel 2007 [Solved/Closed]

 Praveen -

i want to know that howcan I change the dateformat in
excel 2007 worksheet if I want it like :-


plz. answer me soon.


1 reply

1. Select a cell to be formatted I specific date format.
2. Right click and choose "Format Cells...".
3. In the "Number" tab select "Custom" and type the format you want. For example:
4. Click "OK" button.
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you Chris!!!
Thank you VERY, VERY much for your answer! So helpful!!
I have to chage date from 42464 this format like this 21-Apr-16
plz help me anybody and plz send advice to ***@***
Thank you so so so much

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!