| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returned instead of result
A third possiblity.
OP literally did not preface the string with the "=" sign. Gord On Tue, 18 May 2010 11:27:01 -0700, Gary''s Student wrote: There are two possible reasons you would seee the formula in a cell rather than the value; 1. The cell was formatted as Text. To fix this, re-format the cell to General and re-endter the formula 2. The Formula Display mode is on. To fix this just touch CNTRL-` |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| different values shown when #DIV/0! error is returned as result | Excel Discussion (Misc queries) | |||
| Excel, function, result to be returned in another designated cell | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Value returned from Formula changes with the Date | Excel Worksheet Functions | |||
| Result not being returned | Excel Worksheet Functions | |||
Hybrid Mode
