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.
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.
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.
