=--SUBSTITUTE(A1,".","")
and copy the formula down


"snickers22" wrote in message
...
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.