If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
######## as the answerin the cell. How do you correct?
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. |
#2
|
|||
|
|||
Expand the width of the column
"Hoot" wrote in 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. |
#3
|
|||
|
|||
I take it that it is not as simple as just increasing the column width?
-- Return email address is not as DEEP as it appears "Hoot" wrote in 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. |
#4
|
|||
|
|||
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). Hoot wrote: 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. -- Dave Peterson |
#5
|
|||
|
|||
-----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. |
#6
|
|||
|
|||
G'day Hoot
May be just a simple column problem being too small (narrow) to carry the value created. hope this helps Graeme |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I conditionally UNLOCK a cell? | Chris | Worksheet Functions | 1 | August 31st, 2004 07:47 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
**Trying to use answer from another formula cell in another formula | KIMBERLY | Worksheet Functions | 1 | April 27th, 2004 06:22 PM |
Finding cell references | Gary Thomson | Worksheet Functions | 0 | December 4th, 2003 12:08 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |