Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My question is how to stop the automatic 12 digit number conversion to
scientific format. I cant stand it. I am sick of having to convert every time I open excell, is there a way to stop this in the excel settings? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
To reset the number format, click General in the Category list. Cells that are formatted with the General format have no specific number format. However, the General format does use exponential notation for large numbers (12 or more digits). To remove the exponential notation from large numbers, you can apply a different number format, such as Number. Challa Prabhu "nathan" wrote: My question is how to stop the automatic 12 digit number conversion to scientific format. I cant stand it. I am sick of having to convert every time I open excell, is there a way to stop this in the excel settings? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent General format from using scientific notation? | Excel Discussion (Misc queries) | |||
Cell changes from General format to Scientific | Excel Worksheet Functions | |||
Scientific formating like (a.b+-x.y) 10-z cts/sec | New Users to Excel | |||
Stop scientific format | Excel Discussion (Misc queries) | |||
Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) |