ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "E" Scientific Notation (https://www.excelbanter.com/excel-discussion-misc-queries/120743-re-e-scientific-notation.html)

Dave F

"E" Scientific Notation
 
Two ways:

1) Format the cell as text.
2) Put an apostrophe to the left of the text string. This apostropher will
appear in the formula bar, but not in the cell itself.

Dave
--
Brevity is the soul of wit.


"pthom" wrote:

When I try to enter the code 5E123 excel assumes that I am entering
scientific notation, and it wont allow me to enter this. How can I?



All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com