How do you remove the decimal point in a number?

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

On Fri, 6 Aug 2004 12:51:04 -0700, carter
wrote:

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

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

"Ron Rosenfeld" wrote:

On Fri, 6 Aug 2004 12:51:04 -0700, carter
wrote:

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

On Fri, 6 Aug 2004 13:19:02 -0700, carter
wrote:

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

"Ron Rosenfeld" wrote:

On Fri, 6 Aug 2004 12:51:04 -0700, carter
wrote:

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


Sometimes the simple things are not so obvious :-)

Thanks for the followup.


--ron

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


---
Message posted from http://www.ExcelForum.com/

On Fri, 6 Aug 2004 21:08:31 -0500, duane
wrote:

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