Hi

If you enter the dates as Text, rather than Excel dates you can do this.
Prefix you entry with a single quote to force it to be text
'30-feb-1999

--
Regards

Roger Govier


"eesh" wrote in message
...
i wanted to display
( 01-jan-1999
05-jan-1999
......30-jan-1999
01-feb-1999
05-feb-1999
.
..
..30-feb-1999
.
.
...30-dec-2006)
in a column of excel
i know that there will be no 30th feb,but it's a requirement

pls help