| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changes cell function to answer
When I have formatted a cell as Normal and then go enter a formula such as
+33/365 (using a plus at the beginning of the formual instead of an equals sign) Does anyone know why excell automatically changes the formula to the answer of 0.9041095?? I no longer have the formula in the cell just the answer? It only happens if I have that formatting and use the +sign (which is easier to use because it is on the number pad) Any help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "IF" function: Can a calculation be an answer? help plz | Excel Worksheet Functions | |||
| function displaying in an Excel cell instead of the answer | Excel Discussion (Misc queries) | |||
| how do i get answer is 1 from CELL("color",sth) function? | Excel Discussion (Misc queries) | |||
| Answer in Red in =IF function | Excel Worksheet Functions | |||
| Sum Function sometimes displays incorrect answer | Excel Worksheet Functions | |||
Threaded Mode
