How to determine the value?
 

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

How to determine the value?
 

=10^(2-INT(LOG10(A2)))
--
David Biddulph

"Eric" wrote in message
...
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

How to determine the value?
 

Try the formula:

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Eric" wrote:

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

How to determine the value?
 

Actually it should be:

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Satti Charvak" wrote:

Try the formula:

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Eric" wrote:

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