Select the range of cells in question
Goto the menu EditReplace
Find what: -
Replace with: nothing, leave this empty
Replace All

--
Biff
Microsoft Excel MVP


"Shawna" wrote in message
...
Hello and please help. I need to know how to change the following number
in
my cell from 1234-5678 to read as 12345678. Basically I want to remove
the -
from my number. I have over 14000 lines and each number in the column
needs
to have the dash remove from the number. Thanks