Remove Dashes from Social Security Numbers
That worked perfectly. Thank you!!!!
"Nobody" wrote:
Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000
---------------
mama no teeth
"catrose" wrote:
How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX
and I still need the 0's (zeroes) o show.
|