| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Maximum viewable numbers in a cell
A cell doesn't seem to show more than 16 numers it turns the last 3, in my
case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not a big user of Excel, hense this, i assume a simple solution. -- Regards Tony. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Maximum viewable numbers in a cell
15 digit is an Excel limitation!
Regards, Stefi €˛Tony€¯ ezt Ć*rta: A cell doesn't seem to show more than 16 numers it turns the last 3, in my case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not a big user of Excel, hense this, i assume a simple solution. -- Regards Tony. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Maximum viewable numbers in a cell
See http://www.cpearson.com/excel/rounding.htm
Excel's precision is 15 digits... If you want to use bigger numbers then you can store them as text... "Tony" wrote: A cell doesn't seem to show more than 16 numers it turns the last 3, in my case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not a big user of Excel, hense this, i assume a simple solution. -- Regards Tony. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel 2003 - Worksheets on viewable | Excel Worksheet Functions | |||
| Excel file not viewable when opened | Excel Discussion (Misc queries) | |||
| Maximum Numbers from a series of Columns | Excel Discussion (Misc queries) | |||
| How do I create a viewable formula using calculated fields?)Excel | Excel Discussion (Misc queries) | |||
| MAXIMUM NUMBERS IN CELL | New Users to Excel | |||
Linear Mode
