Hi Sofie

i have just seen that Stefi posted the same solution as I did.
It sounds as though the cell where you are pasting the formula is
formatted as Text (from your previous efforts).
Format the cell as General, then paste the formula and all should work
OK.

--
Regards

Roger Govier


"sofie" wrote in message
...
I just tried it, it doesn't seem to work. It doesn't "behave" as a
formula.
When I copied and pasted your formula nothing happend...

"Stefi" skrev:

Use a Helper column filled with this formula:
=TEXT(SUBSTITUTE(A1,"-",""),"00000000")

format the original column as text and paste special/value the helper
column
back to the original column!

Regards,
Stefi

"sofie" ezt írta:

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!