loosing test fomat after using replace command
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? |
loosing test fomat after using replace command
If you format the resulting cell as: 000000000
You'll see your leading 0's. And if you save as a .csv, then open that .csv in Notepad, you'll be able to see how it worked. Or... Use a helper column of formulas: =substitute(a1,"-","") And drag down. This will return a string. Richard Miller wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 11:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com