Hi MFS,

You can use following function, assuming you have the data in cell A1:-
=VALUE(MID(A1,1,3))

Note: - In the formula, you can increast "3" to get more and less numbers
picking up. Thanks.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"MFS" wrote:

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22