Formula returned instead of 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.
--
Best Regards,
Luke M
"Reno" wrote in message
...
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.
|