Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Excel only has 15 digit precision.
If you need more, you will require a different program. Preface the number with a single quote(apostrophe) or pre-format the cells to Text. Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 17:19:02 -0700, trafficpower wrote: When I enter a number in a cell, like a serial number with 16 digits, it always makes the last number a zero even when it isn't. For instance I will type 23467923400998 but it will show 23467923400990 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |