LEFT returns text; convert text to number with a pair of negation operators;
=--LEFT(A1,3)
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"assaf1978" wrote in message
...
Hi,
Why can't I treat the result of the LEFT function as a number (if taken
from
a string of numbers) and not as a string?
I tried format cells but to no avail.

Thanks,
Assaf.