Need to change numbers with dashes to numbers with no dashes
Editreplace, find - replace with leave blank, then use a custom format of
000000000
for SSN
and
0000000000
for phone numbers
Of course if the original are using SSN formatting then you only need to
change that.
Finally, if you need a physical leading zero use a help column after the
dashes have been replaced and use
=TEXT(A1,"000000000")
copy down and then copy and paste special as values in place
--
Regards,
Peo Sjoblom
"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.
|