💻 Software
How can you make Excel 2007 stop formatting large numbers as scientific notation?
Fresh5 days ago
Mar 15, 202631844 viewsConfidence Score0%
0%
Problem
Kind of the inverse of this question. I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal tool for this sort of thing. Except for one behavior: Excel attempts to outwit the data in the CSV, a…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can you make Excel 2007 stop formatting large numbers as scientific notation?
Low Risk
You can, but it takes a couple of manual steps. These steps are from Excel 2003, but I'd assume the wizard is similar in 2007: Rename the file as TXT. Don't double-click it. Open Excel Click File, Open Locate and double-click the text file It should…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix