| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing default or hidden rules within microsoft excel?
In Excel, anytime I enter a 16 digit number it automatically changes it to:
1.23457E+15 than if I change the format of cells to 0 decimal points, it automatically changes the last digit in a 16 digit number to a 0. How do I detect this setting, or if it is a default or embedded rule how can I change this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Sheet default setting. | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
| Excell VS Office | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
Linear Mode
