Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV View

bmsolis1
Level 1

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.

0 Cheers

This discussion has been locked. No new contributions can be made. You may start a new discussion here

1 Best Answer

Accepted Solutions
Happy-Tax
Level 5

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.

View solution in original post

2 Comments 2
Happy-Tax
Level 5

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.

bmsolis1
Level 1

Thank you.  

0 Cheers