ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   On Excel what does ##### mean when it is in a cell? (https://www.excelbanter.com/excel-worksheet-functions/51145-excel-what-does-mean-when-cell.html)

Tyler

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

Jezebel

On Excel what does ##### mean when it is 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?




Dave Peterson

On Excel what does ##### mean when it is 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

George Nicholson

On Excel what does ##### mean when it is in a cell?
 
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?






Jezebel

On Excel what does ##### mean when it is 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?









All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com