Dates in cells are no longer visable but are showing as ########
 

My column of cells are formatted as date (03/04/08). First 16 lines in
column are showing correctly but now all I see when I imput the correct date
(different each time) is #######. Sheet is not locked.

Dates in cells are no longer visable but are showing as ########
 

Widen the column

"joh" wrote:

My column of cells are formatted as date (03/04/08). First 16 lines in
column are showing correctly but now all I see when I imput the correct date
(different each time) is #######. Sheet is not locked.

Dates in cells are no longer visable but are showing as ########
 

Or use a smaller font.

Or make sure that the text isn't showing a 4 digit year.

joh wrote:

My column of cells are formatted as date (03/04/08). First 16 lines in
column are showing correctly but now all I see when I imput the correct date
(different each time) is #######. Sheet is not locked.

--

Dave Peterson