View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sofie sofie is offline
external usenet poster
 
Posts: 7
Default remove -, keep 0 in phonenumber

I need to format phonenumbers of the type 045-69825 to 04569825.
When I try the search and replace for the -, I lose the 0 in the beginning
of the number. I treid formating the cells to text first, but the 0 still
goes away.

Help, anyone?