How to determine the value?

[Eric]

Does anyone have any suggestions on how to determine the values?
I would like to multiple value, and make any number to be 3 digits numbers.
For example, there is 12345 in cell A1, it will become 123.45 by multiple
0.01, then 0.01 will be returned in cell B1.
For example, there is 123 in cell A1, it will become 123 by multiple 1, then
1 will be returned in cell B1.
For example, there is 1.2345 in cell A1, it will become 123.45 by multiple
100, then 100 will be returned in cell B1.
Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

 

[Satti Charvak]

Try the formula:

=(A1/(POWER(10,(LEN(INT(A1))-3))))/A1

 

[Satti Charvak]

Actually it should be:

=1/(POWER(10,(LEN(INT(A1))-3)))