Ask Your Question
0

Why do I get #### when inputting the date into my spreadsheet cell?

asked 2018-01-29 12:55:43 +0200

del67 gravatar image

My original xls spreadsheet is on a memory stick and was created in 2005. All other cells etc seem ok but the date always changes to #### when inputted.

edit retag flag offensive close merge delete

Comments

If you meant "###" , it is a signal that the cell contents are too large to be displayed inside the cell bounds.

In that case you could make your cell wider to display the value.

HTH, lib

librebel gravatar imagelibrebel ( 2018-01-29 13:08:06 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2018-01-29 14:23:44 +0200

gnezlek gravatar image

updated 2018-01-29 16:03:12 +0200

Make sure you actually have day / date format specified for the cell(s) in question. Excel kept track of dates as days + portions of days since Jan 01,1900 as I recall, so you could have some bizarre value of 43190.7 (or thereabouts) for January 29, 2018, or if the default kicks in it might include the calendar date as well as the time. OR, just start by making the column wide enough so you can see what is going on :-D

edit flag offensive delete link more
1

answered 2018-01-29 20:32:17 +0200

erAck gravatar image

If ### is displayed instead of a numeric or date value that means the column is too narrow. Increase column width, most comfortably just by having the cell cursor in the column in question and press Shift+Alt+Right

edit flag offensive delete link more
0

answered 2018-01-30 08:45:22 +0200

del67 gravatar image

Thanks everyone. I investigated myself a bit more after I posted and realised that the column just needed to be formatted to 'Date' and all was normal after that. I did an Excel course about 20 years ago and my inspiration must have come from there....

edit flag offensive delete link more

Comments

Good job, In that case please mark the answer from @gnezlek as Correct, by clicking on the checkmark icon at the left side of his answer.

librebel gravatar imagelibrebel ( 2018-01-30 09:38:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-29 12:55:43 +0200

Seen: 69 times

Last updated: Jan 30 '18