| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Supress Scientific Numbers??
Hi ...
Is there any way to get Excel to not display numbers in scientific format?? To force it to display 1.86E+08 as whatever the number really is?? Thanks, Sam |
|
#2
|
|||
|
|||
|
Hi Sam
Have a look at Format / Cells/ Number -- Michael Mitchelson "Sam" wrote: Hi ... Is there any way to get Excel to not display numbers in scientific format?? To force it to display 1.86E+08 as whatever the number really is?? Thanks, Sam |
|
#3
|
|||
|
|||
|
What "the number REALLY is"!!! if X=1.86e-3 then that is what x reallly is.
The decimal system is not the only way of showing numbers. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sam" wrote in message ink.net... Hi ... Is there any way to get Excel to not display numbers in scientific format?? To force it to display 1.86E+08 as whatever the number really is?? Thanks, Sam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) | |||
Linear Mode
