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.
 

Question Info


Last updated May 7, 2019 Views 49,687 Applies to:
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

38 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.