D
Darla
I have a 6 digit number in a cell. I want the first 3 digits of it to appear
in another cell. What is the formula?
in another cell. What is the formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
=LEFT(A1,3)*1
Or, to make it a little more robust:
=IF(LEN(A1)<3,"",LEFT(A1,3)*1)
Biff
Or, to make it a little more robust:
=IF(LEN(A1)<3,"",LEFT(A1,3)*1)
Biff
N
Niek Otten
=LEFT(A1,3)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
P
Paul Sheppard
Darla said:I have a 6 digit number in a cell. I want the first 3 digits of it to
appear
in another cell. What is the formula?
Hi Darla
Try > =MID(A1,1,LEN(A1)-3) in cell A2 if 6 digit no in A1, change cell
references to suit
D
Dave Peterson
One more:
=INT(A1/1000)
=INT(A1/1000)
I have a 6 digit number in a cell. I want the first 3 digits of it to appear
in another cell. What is the formula?
D
Dana DeLouis
Just to be different:
=Quotient(A1,1000)
=Quotient(A1,1000)