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?

remove -, keep 0 in phonenumber
 

Hi Sofie

One way
=TEXT(SUBSTITUTE(A1,"-",""),"00000000")

--
Regards

Roger Govier


"sofie" wrote in message
...
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?

remove -, keep 0 in phonenumber
 

Thanx, I'll try that!

"Roger Govier" skrev:

Hi Sofie

One way
=TEXT(SUBSTITUTE(A1,"-",""),"00000000")

--
Regards

Roger Govier


"sofie" wrote in message
...
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?