| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function does not calculate remain as =SUM(E9:E10)
All functions remain in text format and my worksheet does not calculate it. I
am on auto for calculate? A simple addition, a simple IF does not execute??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function does not calculate remain as =SUM(E9:E10)
Check and make sure that the format of the cells containing the formula is
NOT text... change it to GENERAL. If that does not help then make sure that there is no ' at the beginning of the cell. Finally press CTRL-` once... ` is on the key having ~, usually on the top left corner of the key board. "Claude" wrote: All functions remain in text format and my worksheet does not calculate it. I am on auto for calculate? A simple addition, a simple IF does not execute??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Temp files remain | Excel Discussion (Misc queries) | |||
| Table headers to remain on top | Excel Discussion (Misc queries) | |||
| How to freeze cells to always remain the same value | Excel Worksheet Functions | |||
| Will 7 IFs remain ? | Excel Worksheet Functions | |||
| i can not get full screen to remain off | Excel Discussion (Misc queries) | |||
Linear Mode
