Put 100 in an empty cell, copy it, select the numbers and do editpaste
special and select multiply
this assumes you have 2 decimals for all your entries
--
Regards,
Peo Sjoblom
"kim12372ingram" wrote in message
...
I need to change 5523.44 to 552344 with no decimals in a spreadsheet.
|