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