excel 97 cell format date shows #

I want to enter number in the cell and format it as date for fast entering data. When I do fromat cell, it shows ##### in date function. I increased the column width but no effect. Is there any way to do that.