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
Hello,

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

monday,1dec.2008

plz. answer me soon.

regards
pankaj
See more 

22 replies

+43
Helpful
21
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: dd.mm.yyyy
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