Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2002: I get formulae displaying in cells rather than value
On a seemingly random basis a cell will display a formula rather than a
value. Audit message says that there is a constant in the formula, though no value has been changed from a cell that behaves as expected. Is it me? |
#2
|
|||
|
|||
More information: formula entered is =IF(I7="BWE","WE_EARLY")- this formula
displays in cell rather than value. It appears to be seen by cell only as text, even when generated and evaluating correctly in the Function wizard. |
#3
|
|||
|
|||
Sometimes excel likes to help.
Try this on a blank worksheet. Put today's date in A1 (ctrl-; will work) Put =A1 in B1 That value in B1 was formatted as a date. Now format A2 as Text (format|Cells|number tab) put ASDF in A2 put =A2 in B2 You get the nice result. Now with B2 selected, hit F2, then enter (pretend you're editing the cell's formula). Excel saw the "sending" cell formatted as Text and changed B2 to Text. The only thing you can do is reformat the formula cell and then F2|Enter to make it a formula again. (You can't stop this behavior (as far as I know).) Matilda wrote: On a seemingly random basis a cell will display a formula rather than a value. Audit message says that there is a constant in the formula, though no value has been changed from a cell that behaves as expected. Is it me? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
Excel 2000 to Excel 2002 problem | Excel Discussion (Misc queries) | |||
Excel 2002 crashes | New Users to Excel | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |