Jan-20-2023, 08:15 PM
You cannot format excel using a CSV file. You can save format information in an excel file (.xlsx). I doubt it is worth the trouble, and it is not applicable to your problem. This is an issue of what you see is not what you get. The data will be -0.000005 regardless of the width of the column. Only the display changes when you make the column too narrow to display all those digits. Make the column even narrower and you might see large numbers displayed as ####. The number is still there, only the display changes.