three digits

[MFS]

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

 

[Jacob Skaria]

A1 = 5 digit number
=value(LEFT(A1,3))

If this post helps click Yes

 

[Mike H]

try,

=left(a1,3)

mike

 

[DILipandey]

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.)
[email protected]
[email protected]
New Delhi, India