=LEFT(A1,3)*1

Or, to make it a little more robust:

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

Biff

"Darla" wrote in message
...
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?