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

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.
Was this answer helpful?  
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