Ask Your Question

Why am I getting ### in a date formatted field? [closed]

asked 2016-03-19 22:08:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm not a regular user of spreadsheets. I'm taking .xls sheet and changing it with calc. When I set a cell's format to Date(1999-12-31) and enter "2016-03-01", I get "###". This is in a row with bold text in some of the cells. Any suggestions?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2017-06-07 22:58:06.270872

2 Answers

Sort by » oldest newest most voted

answered 2016-03-19 22:37:58 +0200

Ratslinger gravatar image

The column is too narrow to display the date. Right click on the column heading and select 'Column width...' to change or you can hover the mouse on the right vertical line of the column heading (will change to double arrows), hold down the left mouse button & drag the line to the width wanted.

edit flag offensive delete link more


Or use Alt+Right on such a cell until the column is wide enough.

erAck gravatar imageerAck ( 2017-06-07 22:57:31 +0200 )edit

answered 2016-03-19 22:37:15 +0200

horst gravatar image

Make the cell(s) wider until the date string appears.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-03-19 22:08:32 +0200

Seen: 1,778 times

Last updated: Mar 19 '16