How do you remove the decimal point in a number?

[Guest]

If you have 124.70 in a cell is there a way to remove the decimal point and
show it as 12470?

 

[Ron Rosenfeld]

If you have 124.70 in a cell is there a way to remove the decimal point and
show it as 12470?

Multiply by 100

124.70 * 100 = 12470


--ron

 

[Guest]

Da, that will work, thanks! Not exactly what I was thinking of, but if it
orks it works! Thanks again!

 

[Ron Rosenfeld]

Da, that will work, thanks! Not exactly what I was thinking of, but if it
orks it works! Thanks again!

Sometimes the simple things are not so obvious

Thanks for the followup.


--ron

 

[duane]

for an unknown # of places to the right of the decimal point try

=10^(LEN(A1)-SEARCH(".",A1))*A1

assuming your # is in cell a

 

[Ron Rosenfeld]

for an unknown # of places to the right of the decimal point try

=10^(LEN(A1)-SEARCH(".",A1))*A1

assuming your # is in cell a1

Of course, that formula will give an error if there are no places to the right
of the decimal point.

Another formula that works would be:

=A1*10^(-1+MATCH(TRUE,A1*10^(-1+ROW(INDIRECT("1:16")))
=INT(A1*10^(-1+ROW(INDIRECT("1:16")))),0))

entered as an *array* formula.


--ron