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

-
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 

1 reply

Best answer
39
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: dd.mm.yyyy
4. Click "OK" button.

Say "Thank you" 39

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

CCM 3374 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