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?
|