Copy the cell that has the format you like and paste format it to the cells
that you want to have the date format.



"s2m2" wrote in message
...
i'm making a spreedsheet in office excel, in column A I have a list of
dates.
I would type in 4/5 for an date and excel would automatic change the date
to
4-Apr. I like this way, but when I got to cell 26, the change will not
happen. I type in 4/5 and I get just the number 1 in the cell, for the
rest
of the cells down, can someone help me.