If a number is in cell A1 then =LEFT(A1,1) will return its most significant
digit.
--
Gary's Student


"Kelly O." wrote:

I am trying to find a formula that will allow me to extract only the very
first number in a cell. For example, if I have the number 123456 in cell A2,
I would like a formula in cell A1 that will give me only the value 1; if I
have the number 234567 in cell B2, I only want the value 2 in cell B2, and so
on. Further, is it possible to capture more than the first number if I need
more than that?

Thanks, Kelly