Forum Discussion
Formatting CSV numeric values
Bennadeau The end user has to format the column the way you suggested, formatting the cell with a "Custom" format, and replacing the "General" with twelve zeroes. This works, however, as an IT department furnishing the Excelsheet, we want to circumvent the user from formatting the column.
The thing is that what you are talking about isn't a CSV formatting issue, it is an excel display issue. Excel automatically makes those numbers into sci format. There is nothing you can change in excel to change that when you send a file. It is all about the User and they would have to change the format.
If you want to control the format and lock the workbook you would have to turn the CSV into an excel file and do all the number formatting and then lock the sheet so the end user doesn't have to do it.
Keep in mind all a csv file is, is a text file that excel recognizes commas as a way to make a column.
Flikkery