CSV file truncating 0's on left
Posted on 2013-12-04
I have an excel spreadsheet. In the first column I have numbers with padded 0's, in another column I have the last 4 of the SSN:
When I save the file as a CSV file, it is removing my padded zeros:
I want to retain the 0's and have it NOT remove the 0's for both columns. How do I do that?