Unreadable date

M

Mark

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?
 
S

Sloth

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
 
Top