I'm also having the same issue as Anita - but I don't understand the
directions you cite: =TEXT(LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4))

Are you saying put 000-11-1234 in A1 and then this formula in B1?

Is there another step after adding the formula you cite?


"Nick Hodge" wrote:

Anita

Not sure I do, but it sound like you want to remove the hyphens. If the SS#
are in column A in B1 enter

=TEXT(LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4))

and copy down

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


"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.