How do I get excel to not mess around with the formatting of a .csv file
Fresh3 days ago
Mar 15, 202631808 viewsConfidence Score0%
0%
Problem
I have two issues with a csv file that occur when I try and edit it in Excel. I have an ISBN column that gets reformatted to scientific format every time I save the file The encoding for the file is changed from UTF-8 to ANSI when I open the file. It is really, really frustrating and a complete was…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I get excel to not mess around with the formatting of a .csv file
Low Risk
Don't double click on the CSV file because that will auto format the columns. Instead create a new spreadsheet and use the Data Import and you can manually format the columns to TEXT to avoid cutting off numbers and silly auto formatting.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix