The OP's question indicated that numbers were positive and specified
the multiplicites.
You could replace log(...) by log(abs(...)) in the formula do deal with
negatives

=A1*10^(LEN(ABS(A1)/10^(INT(LOG(ABS(A1)))+1))-INT(LOG(ABS(A1)))-3)

and if you wanted also add a condtion for 0.

Gary''s Student wrote:

and if A1 contains -100 ??
--
Gary's Student


"Lori" wrote:

This also seems to work:

=A1*10^(LEN(A1/10^(INT(LOG(A1))+1))-INT(LOG(A1))-3)

for a number in A1, to get the other number just divide the original by
this result.

Perus wrote:

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.