Ask Your Question

Calc: semi random dates not recognized [closed]

asked 2012-08-29 18:29:37 +0100

Greg H gravatar image

Some dates in column A are not being recognized as such. I extended a series of dates by dragging the selection handle and find that some are displayed as three hash marks (###) instead of a formatted date. There seems to be a pattern, but it is not consistent (notice October not listed below). The following dates become hashes anywhere they are entered in column A: 9/5/2012, 9/12/2012, 9/19/2012, 11/7/2012, 11/14/2012, 11/21/2012, 11/28/2012, 12/12/2012, 12/19/2012, 12/26/2012... Perhaps this is a bug? Thanks for any suggestions.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 20:50:01.363830

1 Answer

Sort by » oldest newest most voted

answered 2012-08-29 21:26:27 +0100

w_whalley gravatar image

The hash marks indicate that the cell is not wide enough to display the contents.

Is your date format like "September 19, 2012"? I can reproduce your problem with that date format if the cell format is set that way and the cell width is just wide enough to display the October dates.

Fix: 1) Widen the cells 2) choose a different date format 3) choose a smaller font, or some combination of these.

edit flag offensive delete link more


Thank you, I should have known that! (Feeling kind of stupid now...) :)

Greg H gravatar imageGreg H ( 2012-08-31 04:01:20 +0100 )edit

Question Tools


Asked: 2012-08-29 18:29:37 +0100

Seen: 827 times

Last updated: Aug 29 '12