How to return first 3 digits of a number?

[Curalice]

Column A has 10 digit numbers, I want Column B to have only the first
three digits of each number.
Please help.
Thanks!

 

[Bob Phillips]

=--LEFT(A1,3)

 

[Sandy Mann]

Try:

=LEFT(A4,3)

which return the three *numbers* as text

if you need the three numbers to still be numbers use:

=--LEFT(A4,3)

--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk