That's beautiful.

Thanks Kostis

Pat



"vezerid" wrote in message
ups.com...
The following formula will return text and thus preserve the 00's.

=SUBSTITUTE(A2,"-","")

HTH
Kostis Vezerides

On Jun 21, 8:31 pm, "Pat Jones" wrote:
Thanks Pete;

That works except for one thing that I didn't realize was important -
many
of these numbers start with a zero (0). The find and replace got rid of
the
zeros. I then formatted the cells as text, but the zeros were still gone
on
some - but not all - of the results.

Any ideas how to preserve those zeros ?

Cheers;
Pat

"Pete_UK" wrote in message

ps.com...

Highlight the column and do Find & Replace (CTRL-H):

Find What: -
Replace with: (leave empty)

Click Replace All.

Note that if you have "numbers" like 0012-3456, you will lose the
leading zeros and end up with 123456.

Hope this helps.

Pete

On Jun 21, 4:39 pm, "Pat Jones" wrote:
Hi;

I have a long column of numbers that contain "-" (I call them dashes).
I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Thanks;

Pat