| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
how do I turn off automatic truncation of long numbers in excel?
|
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
how do I turn off automatic truncation of long numbers in excel?
Excel has a 15 significant digits limitation on numbers.
Precede the long number with an apostrophe. This makes the number text and cannot be used for calculations. Gord Dibben MS Excel MVP On Fri, 7 Aug 2009 08:32:01 -0700, paul n <paul wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turn off automatic incremementing of numbers when using drag & dr. | Excel Discussion (Misc queries) | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| the end of long numbers turn to 0s how do i stop that? | New Users to Excel | |||
| how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
