=LEFT(A1,3)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

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