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

Ask a question PANKAJ - Last answered on Aug 26, 2017 at 10:01 PM by Praveen

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


plz. answer me soon.

plus moins
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?  
Micuzzo- Feb 5, 2016 at 12:17 AM
Thank you Chris!!!
anonymos- Feb 11, 2016 at 11:28 AM
Thank you VERY, VERY much for your answer! So helpful!!
Dhinesh- May 11, 2016 at 12:27 AM
I have to chage date from 42464 this format like this 21-Apr-16
plz help me anybody and plz send advice to ***@***
cooper- Apr 3, 2017 at 06:00 AM
Thank you so so so much

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!