Leading "0"

B

Barbara

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.
 
D

David Biddulph

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

Dave Peterson

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

format|Cells|number tab|Custom category:
0000000000
 
Top