Formula returned instead of result

R

Reno

from downloaded file, in A1 have CS1234567 and want the numbers only, used
value(mid(a1,2,7)) and instead of 1234567, it returned formula
value(mid(a1,2,7)) . formatted the col for number, and general with same
formula returned. Also deleted column then added column with same result.
 
L

Luke M

Try formatting the cell to something other than text, THEN input the
formula.

Still not working?

Try hitting Ctrl+` (the key to the left of 1) to switch out of formula view
mode.
 
G

Gary''s Student

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-`
 
G

Gord Dibben

A third possiblity.

OP literally did not preface the string with the "=" sign.


Gord
 
Top