Skip to main content
K
kedaniels
Level 3
August 24, 2020
Question

Lacerte Export

  • August 24, 2020
  • 1 reply
  • 8 views

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 topic has been closed for replies.

    1 reply

    George4Tacks
    George4Tacks
    Level 15
    August 24, 2020

    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.

     

    Answers are easy. Questions are hard!
    Terms & ConditionsAccessibility statement
    Tax software
    Intuit Lacerte Tax
    Intuit ProConnect Tax
    Intuit ProSeries Tax
    Referral Program
    Workflow add-ons
    Intuit Tax Advisor
    Hosting for Lacerte & ProSeries
    eSignature
    Protection Plus
    Pay-by-Refund
    Intuit Link
    Accounting solutions
    QuickBooks Online Accountant
    QuickBooks Accountant Desktop
    EasyACCT
    Training & support
    Training Center
    Learn & Support
    Resources for starting a tax practice
    Tax Pro Center
    How to get started offering advisory services
    Call Sales: 833-564-8436
    Sitemap
    Turbotax icon creditkarma icon QuickBooks icon Mailchimp icon
    About Intuit Join Our Team Press Room Affiliates and Partners Software and Licenses

    © 2026 Intuit Inc. All rights reserved.

    Intuit, QuickBooks, QB, TurboTax, ProConnect, Credit Karma, and Mailchimp 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.

    Terms and Conditions About cookies Manage cookies
    Legal Privacy Security
    TRUSTe
    Products
    T1 Tax Module
    T2/CO-17 Tax Module
    T3 Tax Module
    T4, T5 & Other Tax Forms
    Tax Suites
    Single Returns (OnePay)
    ProFile 20
    QuickBooks Online Accountant
    Pricing
    Pricing & bundles
    Free trial
    Learn
    Getting started
    Training
    Webinars & events
    Support
    Download & activate
    Community & support
    System requirements
    Refer a friend
    Call sales: 1-844-861-3600
    Manage cookies

    © 2026 Intuit Inc. All rights reserved.

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

    Legal Privacy Contact Contact
    Logiciels
    Logiciel d’impôt T1
    T2/CO-17 Tax software
    Logiciel d’impôt T3
    T4, T5 et autres formulaires fiscaux
    Suites Fiscales
    PayezPourUN
    ProFile 20
    Signature Intuit pour ProFile
    QuickBooks en ligne Comptable
    Prix
    Prix et offres groupées
    Essai gratuit
    Apprentissage
    Démarrage
    Formation
    Webinaires et événements
    Soutien
    Télécharger et activer
    Communauté et soutien
    Exigences système
    Recommandez un ami
    Appeler les ventes : 1 800 943-9834
    Paramètres des témoins

    © 2026 Intuit Inc. Tous droits réservés.

    Intuit et QuickBooks sont des marques déposées d’Intuit, Inc. Les modalités, les fonctions, le soutien, les prix et les options de service peuvent être modifiés sans préavis.

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

    Nos offres d’emploi Contactez nous Renseignements juridiques Confidentialité