First back up your data and try this on a copy...........

Highlight the cell(s) with the numbers with the dashes in them, then Edit
Replace FindWhat: - Replacewith: leave blank ReplaceAll..........

Vaya conDios,
Chuck, CABGx3




"Alicia" wrote in message
...
I have 1 column that has a number: 11-22-3333.
Another column has the same number in a different format: 11223333

Is there a formula that will reformat one of these numbers to look like
the
other so I can match up additional data?