Hi,
I'm doing a bunch of data massaging of excel files to get to a point where I can import into a different program. The import data needs to be in .csv format.
No matter what format or process I try trailing zeros are getting removed when i save as the csv.
Data in .xls prior to save:
1.10 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.20 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.130 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.140 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
When I save as csv they are getting changed to
1.1 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.2 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.13 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.14 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
I have done the process numerous times and it always works (sometimes 2-3k Rows of info) with the exception of anything that ends in a zero.
Any ideas?
Thank you in advance.
I'm doing a bunch of data massaging of excel files to get to a point where I can import into a different program. The import data needs to be in .csv format.
No matter what format or process I try trailing zeros are getting removed when i save as the csv.
Data in .xls prior to save:
1.10 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.20 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.130 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.140 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
When I save as csv they are getting changed to
1.1 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.2 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.13 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
1.14 LOTS AND LOTS OF TEXT GOES HERE FOR IMPORT PROCESS
I have done the process numerous times and it always works (sometimes 2-3k Rows of info) with the exception of anything that ends in a zero.
Any ideas?
Thank you in advance.