The LEFT Function
 

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.

The LEFT Function
 

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.

The LEFT Function
 

If A1 contains 123abc then=--LEFT(A1,3) gets you the number (as a number)

The double minus sign is a very common trick
--
Gary''s Student - gsnu200745


"assaf1978" wrote:

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.

The LEFT Function
 

Thank you Bernard & Gary's Student - u've been most helpful!

"assaf1978" wrote:

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.