Skip to main content
Logo

Yearli Guide
Have questions? Our knowledge base has answers.
  1. Yearli Guide
  2. Integrations
  3. Yearli Core & Performance Data Imports

Yearli Excel - Microsoft Excel keep dropping the leading zeros in my Excel file. How do I fix this?

October 19, 2020 13:17

Microsoft Excel formats the data based on the parameters specified for each specific field.  If the fields in the spreadsheet aren't formatted to accept leading zeros, they will be removed by Excel.  During the import process Yearli will add the leading zeros back to SSNs, EINs, and/or zip codes.

Was this article helpful?
1 out of 1 found this helpful

Articles in this section

  • Yearli Excel - How do I get the Excel import template?
  • Yearli Excel - What is the maximum file size for importing?
  • Yearli Excel - Tips for importing 1095-C lines 14, 15, and 16.
  • Yearli Excel - Microsoft Excel keep dropping the trailing zeros during my Excel import. How do I fix this?
  • Yearli Excel - Microsoft Excel keep dropping the leading zeros in my Excel file. How do I fix this?
  • Yearli Excel - How long will it take to import my 1095-C or 1095-B data into Yearli?
  • Yearli Excel - How do I select or mark checkboxes on forms while performing an Excel import?
  • Yearli Excel - How do I import my 1095-B information into Yearli?
  • Yearli Excel - How do I format my Excel file to import the 1095-C data?
  • Yearli Excel - How do I create a W-2 or 1099 Excel import file?
See more

Need more help?

Contact Us

© 2020 Greatland Corporation