System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
To prevent leading zeros from being dropped when opening a CSV file in Excel, perfrom the following operation:
1: Open up a blank Excel spreadsheet
2: Go to the menu option DATA - Import External Data - Import Data
3: Browse to the data file you are trying to open and then format EVERY column as Text
As you can see, the leading zero's are now present in the Excel worksheet