Remove Hyphens from a number

[Mike]

I have numbers in a coulmn that look like this:

01-012-4123 how do I remove only the hyphens (dashes)

 

[Dave Peterson]

Select your range and Edit|Replace

What: - (hyphen)
with: (leave blank)

You may want to format those cells (custom: 000000000)
to keep the leading 0's.

 

[Robin Hammond]

Add a column with something like this in .

=SUBSTITUTE(A1,"-","")

Robin Hammond
www.enhanceddatasystems.com