what does "#########" mean?

  • Thread starter Thread starter Guest
  • Start date Start date
Could mean a couple of things:

1) The column width is not wide enough to display the number in the cell.
Expand the column to see the entire number (or reformat the number to reduce
it's display width requirements.)
2) The cell contains a formula that results in a "negative time"
calculation. Negative times can't be displayed in Excel, no matter how wide
the column.

There may be others, but those are the 2 that come to mind.
 
One more comes to mind.

When a cell is formatted as Text and character length is between 256 and 1024
you can get the ###########

Format to General and usually clears up.


Gord Dibben Excel MVP
 
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 { } mean in excel formulas? 4
What does "" mean in Excel? 2
What does the yellow triangle with an exclamation mark in Outlook mean? 1
what does mean excel? 1
What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 3
What Does It Mean To Be British? 3
In Excel spreadsheet what does Ref # mean? 1
What does "can't empty clipboard" mean? 2

Back
Top