| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does it display #### in my cell?
In cell I25 I have the following formula: =SUM(I11:I14)
All it displays is #####, but when I hover over it, it gives me the correct answer on a popup tip-like window which is $3,400. So, if it knows the answer, why is it displaying with the pound signs instead? I think I've tried everything. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display contents of cell if adjacent cell equals | Excel Worksheet Functions | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
Threaded Mode
