How To Change the Date Format in Excel 2007 [Solved/Closed]

PANKAJ - Nov 26, 2008 at 03:13 AM - Latest reply:  Praveen
- Aug 26, 2017 at 10:01 PM

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


plz. answer me soon.

See more 

22 replies

Best answer
Thank you
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, anonymos 39

Something to say? Add comment

CCM has helped 1801 users 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