I’m creating a csv view from Homebase but it creates the SSN column in NNN-NN-NNNN format. I need it in numbers only without dashes. Does anyone know how to do this? Thanks.
Best Answer Click here
This discussion has been locked. No new contributions can be made. You may start a new discussion here
Create the .csv file and view it in Excel. Copy the SSN column into another worksheet. Use the Find and Replace command (Ctrl-H) to replace the hyphens with nothing, thereby removing the hyphens. Then copy the column back into your .csv file.
Create the .csv file and view it in Excel. Copy the SSN column into another worksheet. Use the Find and Replace command (Ctrl-H) to replace the hyphens with nothing, thereby removing the hyphens. Then copy the column back into your .csv file.
Thank you.
You have clicked a link to a site outside of the Intuit Accountants Community. By clicking "Continue", you will leave the community and be taken to that site instead.