How to change the date format in Excel 2007

Solved/Closed
PANKAJ - Updated on Nov 12, 2018 at 12:42 AM
 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

1 reply

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.
39
Step 3 is applicable if date formats provided by default are not what you want.

In most cases following will work fine:

In the "Number" tab select "Date" and from "Types" list select the most applicable one.
0
thanks
0
tahnks this info is vry usful
0
thaks I solved my problem
0
its very useful thanks frnd
0