On Excel what does ##### mean when it is in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
Usually means that the number is wider than the column. Make the column
wider and you should be fine.
 
It could also be due to a calculation that results in a "negative time".
Excel won't/can't display a negative time, so no matter how wide you make
the column, it will remain filled with ####.
 
amongst other causes, yes



George Nicholson said:
It could also be due to a calculation that results in a "negative time".
Excel won't/can't display a negative time, so no matter how wide you make
the column, it will remain filled with ####.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does the yellow triangle with an exclamation mark in Outlook mean? 1
=AND($B$12<>"",$B$12<TODAY()+60) What does the <> mean in this? 3
What does { } mean in excel formulas? 4
What does " mean in excel 5
What does this formula mean [$-F400]h:mm:ssAM/PM 2
What Does It Mean To Be British? 3
Editorial GDPR: What it is and what it means 1
=+(NUMBER OF CELL) IN A CELL, WHAT DOES IT MEAN?example =+D101 2

Back
Top