View Single Post
  #4   Report Post  
BOB
 
Posts: n/a
Default

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.