Home » Questions » Computers [ Ask a new question ]

How can you make Excel 2007 stop formatting large numbers as scientific notation?

How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question.

Asked by: Guest | Views: 65
Total answers/comments: 2
Guest [Entry]

"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 open a ""Text Import Wizard""
In step one, choose ""Delimited""
In step two, uncheck ""tab"" and check ""comma""
In step three, scroll-over to the last column, shift-click to select all columns, then click ""Text"" as the format.
Ignore the annoying ""Number stored as text"" warnings everywhere

Goes pretty fast with some practice."
Guest [Entry]

"I export from my online banking. I choose to save the file (not open it). It saves in the .csv format. Then I open an excel sheet, in the Data tab in the ""Get & Transform Data"" ribbon, I click on From Text/CSV, choose (double click) the .csv file I saved.

It will open with File Origin, Delimiter and Data Type Detection as headers. Keep everything the same except Data Type Detection - choose Do not detect data types. Then click on Load below. The data will be loaded into your excel sheet with all the digits correctly.

Hope this help. It was a mission to figure this one out"