number formatting

You could do a search and replace. Search for - and replace with nothing.

Barrie

Use Edit | Replace... (Control+H) substituting
all ocurrances of minus (-) with nothing, but
be forewarned that if you have leading zeros
that they'll be eliminated unless you format
you column as "Text" beforehand. Help! I've got a spreadsheet with 3500 rows in it. I have a column A that is formatted #-#####-###-#. I need to remove the dashes (-) from all of the numbers without having to go through each one. Is there a macro of some type that would get this done or an if statement that would step through one by one each record and change the formatting to ########## (minus the dashes). I've tried using custom number formats but they won't change the existing data. Please help me. Thanks in advance.

select the column A,
then Edit,
then Replace
on Find what: type -
on Replace with: leave it blank (not even a space)
search: by Rows
unchecked two other boxes,
then Replace All
should do it

hope this help