Format the cell as text before you put the number in, or format as
0000000000, or use =TEXT(A1,"0000000000")
--
David Biddulph

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