Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scientific notation from a csv file | Excel Discussion (Misc queries) | |||
Scientific Notation with Lower Case "e" | Excel Discussion (Misc queries) | |||
Excle should allow define a fix exponent in scientific notation | Excel Discussion (Misc queries) | |||
Custom format for scientific notation | New Users to Excel | |||
Removing Scientific Notation | New Users to Excel |