The Edit Replace can work on a range of cells <<all at once
Highlight or Select the range then use the Replace what: "-"
Replace With: ""
Click the "Replace All" Button

HTH

"Anita" wrote in message
:

Because I would have to do each number individually, wouldn't I? That's not
an option with as many as we may be bringing in. Thanks, RD

"RagDyer" wrote:

*After* importing, why not try:
<Edit <Replace
And replace the dashes with nothing?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anita" wrote in message
...
We are bringing in a basic ss# with hyphens 000-00-0000 and we need to use
them to apply to a spreadsheet but without the hyphens i.e. 000000000.
We'd
like to format the entire column before importing to the spreadsheet.
Thanks.
I hope that's clearer.

"Nick Hodge" wrote:

Anita

What do you have and what should a ss# look like. Format in Excel are not
like placeholders in Access so you will likely need a temporary helper
column while you add hyphens

pb

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Anita" wrote in message
...
Is there any way to format a column of Social Security numbers without
hyphens? I've tried a custom format but that isn't working. Am I
missing
something? Thanks for your help.