remove -, keep 0 in phonenumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replace - by blank, keep 0 in phonenumber 8
Please critique and criticize...I could use some advice 7
about IndexOf 9
Normalizing 4
Change first character in a cell 5
Join tables by dates 7
Generics / Property Question 4
Adding "0" as leading digits into cells in Excel 2

Back
Top