the ######## just shows when there is not enough room to show the value of
the cell. Either change the format to something smaller
m/d/yyyy
or enlarge the column

"Mark" wrote:

I enter a date into a cell, such as 1/16/2006, and it appears as ########
when I hit enter or click on another cell. Why?