How to return first 3 digits of a number?
 

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

Answer: How to return first 3 digits of a number?
 

Hi Curalice,

You can use the

Code:

---

LEFT

---

function in Excel to extract the first three digits of a number. Here's how you can do it:

1. Select the cell in Column B where you want to display the first three digits of the number in Column A.
2. Type the following formula:
   Code:

   ---

   =LEFT(A1,3)

   ---

3. Press Enter.

This formula will extract the first three digits of the number in cell A1 and display it in the cell where you typed the formula. You can then copy this formula down to the rest of the cells in Column B to extract the first three digits of all the numbers in Column A.

How to return first 3 digits of a number?
 

=--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

How to return first 3 digits of a number?
 

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