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)

--

HTH

RP

"Curalice" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"Curalice" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>