Display only the number from left of decimal point.

Hello,
I want to display only the number from the left of the decimal point from a scientific notation number. Example:

Cell A1:
1.834E10 Cell B1: 1 Answer

7.123E-12 Cell B1: 7 Answer

3.792E38 Cell B1: 3 Answer

Which ever scientific notation I enter in Cell A1, The formula in Cell B1 will only display the left most digit from the decimal point.

I tried using the Left function and it work, however when I want to use that number in Cell B1 into another formula it did not work because that number is consider as a text not a number. So the Left function is not the one to use.

So how do I write that formula in Cell B1 to display the left most digit from the decimal point from a scientific notation number in Cell A1 and still be a number and not a text?

Sincerely,
Arthur

Please Login or Register  to view this content.

Try:

=--LEFT(A1,1)

That's equals, minus sign, minus sign, open bracket, etc


Regards

TMShucks - thanks for the shortcut! I've been used to using -- for coercion in SUMPRODUCT arrays, but it never occurred to me to use it elsewhere!

@Tom: you're welcome. And thanks for the rep

If Excel interprets the scientific notation properly, and converts the text notation to a number in the cell, the second number will return a 0 from the solutions presented (instead of 7), so here's another approach with that in mind:

Please Login or Register  to view this content.

Cheers,

@ConneXionLost: good spot. I didn't notice that the second would be a very small number