Absolutely *NOT*!

You can "edit & replace" the *entire* sheet in one shot ... if you wish!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.