Supress Scientific Numbers??

[Sam]

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

 

[Guest]

Hi Sam
Have a look at
Format / Cells/ Number

 

[Bernard Liengme]

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.