Disabling Scientific Notation

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.
|
Answer
Answer

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?

Yes
No

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.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated June 3, 2021 Views 51,822 Applies to: