How to Fix Truncated CSV Files
FollowSummary:
When downloading a CSV file from Unleashed into Microsoft Excel, some columns consisting of leading zeros or truncated numbers will need to be formatted correctly to display the correct data. This essential when importing files back into Unleashed.
Steps:
- Open the file in Excel
- Highlight necessary column
- Right-click Format Cells
- Under Category, select Number
- Change Decimal Places to 0
- Click Ok
Additional Information
Here is a demonstration of fixing truncated customer code: