Exporting a text field to CVS without losing trailing zero

[jcaulfield]

I am try to take a txt file from ADP and import into JD Edwards. JD Edwards import of excel in limited to 250 rows. I am try to import over a 1000 rows leave the CSV option, but when I save an Excel text field to a CSV file, the CSV file loses its trailing zero.

158802.6181 good
158805.613 bad end with 6130
158805.6151.FICA good


I have tried going thru Access using a "DoCmd.TransferText acExportDelim", but still lose the trailing zeros.

 

[AlphaFrog]

Before you save as CSV, how is something like this 158805.6130 displayed in Excel; with or without the trailing zero?

Try selecting the column and changing the cell formatting to Number with 4 decimal places.