after all, I guess it can only be 1.1 and 1 (which mine gives) or 1 and 1.1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Gary''s Student" wrote in message
...
How about if A11 contains 1.1 ?
--
Gary's Student


"Bob Phillips" wrote:


=IF(A111,A11/10^MAX(IF(MOD(A11,10^ROW(INDIRECT("1:9")))=0,ROW(I NDIRECT("1:9
")))),A11*10^(LEN(A11)-FIND(".",A11)))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

and

=A11/B11

which is not

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Perus" wrote in message
oups.com...
Hello.
I don't know "math english" well so forgive me mistakes.
I've got a question.How should the formula look which will: take
number
from A2 cell and shows me 2 digit number in one cell and 10
multiplicity in another
E.g.
0,12 will be shown as 12 in one cell and 0,01 in another
53000 will be shown as 53 and 1000.
10 multiplicities range is from 0,01 to 1000000000 (10^ -2 to 10^9)
Hope you will help me :D
Kacper.