|
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. |
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. |
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. |
| All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com