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.

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.

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