Select the column.From menu EditReplaceFindwhat put the dash.
Replace with 'leave blank. and OK
--
If this post helps click Yes
---------------
Jacob Skaria


"George" wrote:

Each month I receive an excel spreadsheet and one of the columns has social
security numbers with the dashes. I have to import it into Access without the
dashes, how can I remove the dashes from the social security numbers in Excel
- without doing it by hand ? Is there a way to use format cells to clear the
dashes ?

Thanks