What does ##### mean when its in a cell?

Usually means that the number is wider than the column. Make the column
wider and you should be fine.



"Tyler" wrote in message
...
What does ##### mean when its in a cell?

You have a few responses to your post in .misc, too.

Tyler wrote:

What does ##### mean when its in a cell?

--

Dave Peterson

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 ####.

--
George Nicholson

Remove 'Junk' from return address.


"Jezebel" wrote in message
...
Usually means that the number is wider than the column. Make the column
wider and you should be fine.



"Tyler" wrote in message
...
What does ##### mean when its in a cell?

amongst other causes, yes



"George Nicholson" wrote in message
...
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 ####.

--
George Nicholson

Remove 'Junk' from return address.


"Jezebel" wrote in message
...
Usually means that the number is wider than the column. Make the column
wider and you should be fine.



"Tyler" wrote in message
...
What does ##### mean when its in a cell?