replace - by blank, keep 0 in phonenumber
Hi! I need to format a series of swedish phonenumbers from, for example
045-52698 to 04552698. When I try to use the search and replace, I lose the
0 in the beginning of the number. I also tried to format the cells as text
first, but it doesn't help.
Can anyone help?
Thanx!
|