Formula to return first two digits but skips decimal point

[docmac45]

I need to be able to find the first two digits of a large set of numbers. The problem is when I use the LEFT formula it gives me the first number and then the decimal point instead of the second numeral.

The current formula I am using is =LEFT(B2,2). B2 = 3.5. I need the formula to result in 35.

How can I accomplish this?

[Tony Valko]

Show us several examples of the numbers you're dealing with along with your expected results.

[FDibbins]

Hi, welcome to the forum

Try this...

	E	F
3	3.45678	34
4	0.345678	03
5	34.5678	34
6	345.678	34

F3=LEFT(SUBSTITUTE(E3,".",""),2)

[docmac45]

That works perfectly.

Thank you very much.