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.