If if needs to stay a number with the same value, I don't think you can do it.
If you can change the value Just multiple the number by ten to the number of
decimal places.
If it can be text set up a new column and use
=substitute(a1,".',"")

"LAM" wrote:

I need to format the number cell so that it will still show the numbers after
the decimal, but not show the decimal point at all. It must also display
leading zeros, which is not a problem. I just need a way to strip the
decimal from the number.