we are importing payroll information which includes a SS number formatted
with the dashes (xxx-xx-xxxx). The infomation is used to upload to the state
which requires the data to be in CSV format with no dashes in the SS number.
If we format the SS column as TEXT and apply the replace all to the column
reqursting that (-) be replaced with ( ), the dashes are sucessfully removed,
but the fromat seems to revert to general and any SS number that has a
leading 0 has the zero dropped.

Any suggestion as to how to now loose the leading zero thru the process?