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

with @tiscali.co.uk


"Curalice" wrote in
message ...

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


--
Curalice
------------------------------------------------------------------------
Curalice's Profile:
http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=502652