Excel problem
Nov. 20th, 2014 03:29 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
stormdogI have a technical, Excel-related question for those who know the program.
I'm having issues with Excel displaying large numbers in scientific notation, even when I don't want it to, and *even when they're formatted as text*. I spent over an hour trying to fix this issue earlier this week in order to join a couple of tables within ArcGIS. The only way I could get them to display properly was:
First: format the column of numbers as text. They still showed in scientific notation, so
Second: click each individual cell, then click the field at the top that shows the actual value. This changed the displayed value in the cell. I had to do that for each of the 120-plus cells, which was a pain in the ass, and not practical on a much larger scale.
Do any of you know what I'm taking about? All I can find online is a bunch of people with the same problem, some of whom have a lot of profanity to direct at Excel and Microsoft. I can relate. Were it up to me, Excel would never, ever reformat anything into scientific notation ever. But alas, there seems to be no such option. But why on God's green Earth do they reformat *text* that way?
I'm having issues with Excel displaying large numbers in scientific notation, even when I don't want it to, and *even when they're formatted as text*. I spent over an hour trying to fix this issue earlier this week in order to join a couple of tables within ArcGIS. The only way I could get them to display properly was:
First: format the column of numbers as text. They still showed in scientific notation, so
Second: click each individual cell, then click the field at the top that shows the actual value. This changed the displayed value in the cell. I had to do that for each of the 120-plus cells, which was a pain in the ass, and not practical on a much larger scale.
Do any of you know what I'm taking about? All I can find online is a bunch of people with the same problem, some of whom have a lot of profanity to direct at Excel and Microsoft. I can relate. Were it up to me, Excel would never, ever reformat anything into scientific notation ever. But alas, there seems to be no such option. But why on God's green Earth do they reformat *text* that way?
