Getting the first 3 digits out of 6 digit cells?

[Guest]

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?

 

[Biff]

=LEFT(A1,3)*1

Or, to make it a little more robust:

=IF(LEN(A1)<3,"",LEFT(A1,3)*1)

Biff

 

[Niek Otten]

=LEFT(A1,3)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Paul Sheppard]

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

 

[Dave Peterson]

One more:

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

 

[Dana DeLouis]

Just to be different:

=Quotient(A1,1000)