Removing decimal on Excel 97 from the Currency Column

[mary goodson]

I have a spreadsheet and I need to re-format the currency
that now contains decimals example 133.50 and I need it to
show 13350 (no decimals). I have tried everything and I
cannot get the rid of the decimal. Can someone please
tell me how to do this. Thanks!

 

[Peo Sjoblom]

You can use a help column and a formula

=--SUBSTITUTE(TEXT(A1,"0.00"),".","")

or edit>replace and replace . with nothing
of course it will return 1335 instead or 13350
which the formula will return

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Ron Rosenfeld]

I have a spreadsheet and I need to re-format the currency
that now contains decimals example 133.50 and I need it to
show 13350 (no decimals). I have tried everything and I
cannot get the rid of the decimal. Can someone please
tell me how to do this. Thanks!

Multiply by 100


--ron

 

[Peo Sjoblom]

Doh!

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)