Anyone find a way of disabling scientific notation in Excel. Excel treats text, which "look" like scientific notation as such. For example "5E12". There are work arounds of adding a single quote and remembering to input as "text". Sure would be nice
to just be able to turn it off in a particular workbook.
This is a built in behavior. There is no control of this on the UI. There may be a registry change or other similar thing.
If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
Shane Devenshire
40 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
