CSV trailing zeros

[imeade]

I have a process in place that saves an excel file as a csv but I need the csv to preserve the trailing zero on the postingperiod column.

When the csv is created, it is removing the trailing zero from "2022.10" resulting in "2022.1", is there some vba code out there that can force the trailing zero to remain intact? I have tried various things with no luck.

Thanks

 

[Joe4]

Are you sure that the trailing zero is really being removed?
If you have the Excel file formatted properly to show the trailing zero, and then save as a CSV, it should keep that trailing zero.

Where people get into trouble is that they then try to view the resulting CSV in Excel.
Never view a CSV file in Excel if you want to maintain all the formatting!!!

When you open a CSV file in Excel, Excel automatically applies its own data conversions to the file. So you NOT seeing the data as it actually appears in the CSV.
ALWAYS use a Text Editor (like NotePad) to open and view CSV files if you want to see what the data REALLY looks like in the CSV file.
If you view the created CSV file in NotePad, do you see the trailing zeroes?

 

[imeade]

Are you sure that the trailing zero is really being removed?
If you have the Excel file formatted properly to show the trailing zero, and then save as a CSV, it should keep that trailing zero.

Where people get into trouble is that they then try to view the resulting CSV in Excel.
Never view a CSV file in Excel if you want to maintain all the formatting!!!

When you open a CSV file in Excel, Excel automatically applies its own data conversions to the file. So you NOT seeing the data as it actually appears in the CSV.
ALWAYS use a Text Editor (like NotePad) to open and view CSV files if you want to see what the data REALLY looks like in the CSV file.
If you view the created CSV file in NotePad, do you see the trailing zeroes?

Thanks, there was some confusion on import template within NetSuite, thanks for the insight