Formula returned instead of result

  • Thread starter Thread starter Reno
  • Start date Start date
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.
 
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.
 
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-`
 
Back
Top