Change the format in the cell with the formula to general

--


Regards,


Peo Sjoblom

"evoxfan" wrote in message
...
This is my formula: =LEFT(A8,3)
A8 = "00500"
A8 is formatted as text.
Per the functions argument, the reult should be "005".
Instead, the formula is displayed instead of the result.

Why is this not displayed and how can I correct?