Simple formula

[dione]

I have a series of numbers such as 2223333 in a column. I need to display the first 3 digits in a second column eg 222. What formula do I use?
This message was edited by dione on 2002-03-25 12:26

 

[Barrie Davidson]

On 2002-03-25 12:25, dione wrote:
I have a series of numbers such as 2223333 in a row. I need to display the first 3 digits in a second cell eg 222. What formula do I use?

You can use =LEFT(A1,3). If you want it to be a number, not a string, use =VALUE(LEFT(A1,3))

Regards,