=--LEFT(A1,3)

--

HTH

RP

"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