Welcome back! Ask questions, get answers, and join our large community of tax professionals.
- Topics
- Training
- Community
- Product Help
- Industry Discussions
- User Groups
- Discover
- Resources
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Intuit Accountants Community
- :
- Lacerte Tax
- :
- Lacerte Tax Discussions
- :
- Lacerte Export
Lacerte Export
Options
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
kedaniels
Level 2
08-24-2020
12:06 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Help with exporting needed. I am trying to export client name and zip code only. We are in MA so most of our zip codes start with a ZERO. When I export to CSV it drops the zero. Any way to export as text so it keeps the zero? I'm pretty familiar with Excel but can't get it do what I need.
This discussion has been locked.
No new contributions can be made. You may start a new discussion
here
1 Comment 1
George4Tacks
Level 15
08-24-2020
12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
I believe you can format the column with "Format Cells>Special>Zip Code".
If not: Add an extra column with =TEXT(N#, "00000") where N is the column and # is the row number of the cell you want to change. Copy this to each row and it will convert all digits to length 6.
Here's wishing you many Happy Returns
