Can you just give the range of cells a custom format to show leading 0's?

format|Cells|number tab|Custom category:
0000000000



Barbara wrote:

I need to make a number in one cell, 0,108,250.500, to be without commas or
decimal place, 0108250500, in a new cell. I can make the change with no
problem to take out the commas and decimal (and this is done with a simple
macro, as there will be a long column of these numbers to convert), but I am
having problems figuring out how to get the leading "0".

Thanks for any help anyone can offer.

--

Dave Peterson