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 has helped 2750 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