In VBA, I would just repeatedly divide A11 by 10 until it result was below 1
(counting all the way) Then apply your formula, adjusting C11 by the count.

I am not clever enough (or too lazy) to do this without VBA.

By the way, the op's question was an excellent one, as was your reply. I
might use them as an example this semester.
--
Gary's Student


"Bob Phillips" wrote:

I thought about that, but as his spec (seemed to) discount it, I didn't
bother. You're welcome to enlighten me though.

--

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.