Why is #### coming up to hyde one of the numbers in a cell I am f.

G

Guest

Please help - All of the sudden #### comes up when I mobe on to formulat a
value in excell.
 
D

Dave Peterson

You can get those #### if you format a cell containing a negative value as time
or date.

You can get those #### if you format a cell as a number and make the column too
narrow.

You can get those #### if you format a cell as text and it's pretty long (>256
characters). Just format the cell as General in this case.
 

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

how do i have a cell number increase by 1 each time file opened 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Need Countifs Formula Help 0
Why am I getting #NAME? 6
Multiple functions in a cell help 5
How can I create an array formula for non-sequential cells 7
Help on Adding the same cell in different sheets. 2
Getting the sum of the same cell in defferent exel sheets. 2

Top