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?