Thread: Leading "0"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barbara Barbara is offline
external usenet poster
 
Posts: 97
Default Leading "0"

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.