Customise Excel to Leave Data Unchanged
This guide is for people that are having to open their CSV file to edit something and they are finding that Excel is changing their data.
For example, the leading zero's are disappearing on an invoice number - 001257 is displayed as 1257 or on bank details.
Using Microsoft Excel
The first step is to not open your CSV file when it downloads to your computer. Just leave it where it is for the moment.
Next you need to open a blank Excel file
Click on Data then select 'From Text/CSV' then find your CSV file on your computer and Import. This will open a new pop up window.
Under Delimiter section, Select Comma then Load
To save it click on File, Save As, Select where you want to save it then name the file and change the 'Save As Type' to be 'CSV (Comma delimited) (*.csv)'
You can now upload the CSV into your software
Remember, if you have opened a csv before this is set, it is more than likely that Excel will have changed the data in some way which will later affect the export.
Using Google Sheets
For those who don't have Microsoft Excel, you can try to do so similarly using Google Sheets
File then Import click Upload your selected file.
Upon import, uncheck the "convert text to numbers, dates, formulas" then Import Data and you can review the data from Sheets.
This will now hold your leading 0's. Once you're happy with your list, File, Download and csv.
Use that file to upload direct into Access Capture by Lightyear.