ExcelBanter - Supress Scientific Numbers??

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Supress Scientific Numbers?? (https://www.excelbanter.com/new-users-excel/39605-supress-scientific-numbers.html)

Sam

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

Michael

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

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.
--
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

All times are GMT +1. The time now is 09:25 PM.