The cell was formatted as text when you entered the formula.
Format as General AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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?