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

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

Labels (1)
0 Cheers
1 Solution

Accepted Solutions
Highlighted
Level 4

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 Replies 2
Highlighted
Level 4

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

Highlighted
Level 1

Thank you.  

0 Cheers