View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default Find and Replace

Good day all,
I am trying to change this number 01-465-9273 to show up as 014659273. It is
easy enough to make the (-) go away but it takes the zeros at the beginning
of the number away as well which defeats the purpose

Thanks
--
Pierre