How do you remove the decimal point in a number?

C

carter

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

carter

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

Ron Rosenfeld

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

Sometimes the simple things are not so obvious :)

Thanks for the followup.


--ron
 
D

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
 
R

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
Click to expand...


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
 
Top