Try
In a blank cell enter 100. Copy this cell and then highlight the cells you
want to convert. Right click and click paste special select values and
multiply.
HTH
"snickers22" wrote:
I'm looking to convert a decimal number(3.75) to a non-decimal number(375)
using a formulas. as I have hundreds of these to do.
|