Solved: CSV View

bmsolis1

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.

Happy-Tax

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

Happy-Tax

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

bmsolis1

Thank you.

CSV View

ProSeries Professional

©1997-2020 Intuit, Inc. All rights reserved.

Intuit, QuickBooks, QB, TurboTax, and Mint are registered trademarks of Intuit, Inc. Terms and conditions, features, support, pricing and service options subject to change without notice.

By accessing and using this page you agree to the Terms and Conditions.