######## as the answerin the cell. How do you correct?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Simple command is =F4-F37. Answer in cell continues to be: #######. If I
hold the cursur over the cell it will show the correct answer to the side in
another window.
 
Expand the width of the column


: Simple command is =F4-F37. Answer in cell continues to be: #######. If I
: hold the cursur over the cell it will show the correct answer to the side in
: another window.
 
I take it that it is not as simple as just increasing the column width?
 
Do you have that cell formatted as General?

If you're dealing with times/dates, you can get #### when the results are
negative (and formatted as date/time).
 
-----Original Message-----
Simple command is =F4-F37. Answer in cell continues to be: #######. If I
hold the cursur over the cell it will show the correct answer to the side in
another window.
.
Teh column is to narrow for the number. Widen the column.
Click to expand...
 
G'day Hoot
May be just a simple column problem being too small (narrow) to carry the
value created.
hope this helps
Graeme
 
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

Data Valid - refers to the values of 2 cells 5
Hide divo error 4
multiple cells with isblank formula 5
Problem with if function in excel 4
How to change the color of a cell using conditional formatting? 1
Nested IF function to ignore cells with no data 1
Nested IF - return a blank when compared cells are blank 1
Validation 4

Back
Top