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.