| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Preserve Excel formula entry
When I type an arithmetic formula into a cell, excel automatically condenses
it. For instance, =3/27 becomes =.1111111. I am not referring to the displayed value, but the actual entry in the cell. How can I turn this "feature" off? It is important, because when I return to the sheet months later, the full formula helps me to remember how I decided to calculate the result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel | |||
| display last entry in Excel | Charts and Charting in Excel | |||
| Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
| excel data entry templates | Excel Discussion (Misc queries) | |||
| Repeating formula in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
