Welcome to Payroll and W2 1099 Software Answers ; where you can ask questions and receive answers about payroll software, W2 forms processing, 1099 filing, tax forms, IRS electronic filing and much more.

Contact Us

Real Business Solutions
Live Chat

Real Business Solutions
18313 Distinctive Drive
Orland Park, IL USA 60467

1099 Excel Import, how to keep leading zeros?

0 votes
We are using your software for 1099's this year for the first time.  We are importing using excel and csv format.  Someone sent me a template.  The question we have is if an ID (SSN/Ein) begins with zero the formatting removes the zero when saved.  What should we do in the case?  So far other than this questions everything seems to be working perfectly for us.
asked in 1099 Software by anonymous

1 Answer

0 votes
To keep the leading zeros, please follow these tips:
1. Inside Excel for anything where you want a leading zero, format it as Text so Excel does not modify the column data. 
2. Check and double check the data inside Excel and make sure you see the leading zeros before you save as CSV. 
3. Very Important: Once you save the file as CSV, do not re-open again inside Excel or it will remove the leading zeros. 
answered by RealBusiness