Date format for excel 2007

**friendlykashish** · 02-03-2012, 08:32 AM

Hi to All,

I create a calender & try to formate Date but did n't found Date Only. It is showing month also.

it is like 1-jan instead of 1.

Thanks,

**Pepe Le Mokko** · 02-03-2012, 09:05 AM

Right click - Format cells - Numbers - Custom type is d

**sushil10s** · 02-03-2012, 09:08 AM

See attachment

[You need to custom format dd]

**friendlykashish** · 02-03-2012, 09:26 AM

I did n't find d format. Only d-mmm, d-mmm-yym, m/d/yyy.

Originally Posted by Pepe Le Mokko

Right click - Format cells - Numbers - Custom type is d

**Pepe Le Mokko** · 02-03-2012, 12:37 PM

You will not find it, you must add it yourself

CustomFormat.jpg

Thread: Date format for excel 2007