Need to change numbers with dashes to numbers with no dashes
Are your "numbers" text strings, or are they numbers formatted in special
ways?
If stored as text, all you need to do is =SUBSTITUTE(A1,"-","") to get rid
of the hyphens, and you'll still be left with a text string so won't lose
the leading zeroes.
If you've got SSN stored as a number and formatted to show the hyphens, then
=TEXT(A1,"000000000") would give you leading zeroes padded out to 9 digits.
--
David Biddulph
"cheryltraining" wrote in message
...
The spreadsheet we're working has social security numbers and phone
numbers
with dashes included. Need to remove dashes and not lose the leading zero
in
the SSN.
|