Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Precision
Hi All,
Could you please let me know how to increase the number precision in Excel workbook. I'm aware that the limit is 15,but unfortunately I have more than 16 number to type in a cell. for eg: 1234567891234565 this number will turnout to be 1234567891234560 could you please help on this excluding writing in text format. thanks in advance, yagna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Precision
Hope This Helps:
http://www.cpearson.com/excel/rounding.htm Regards, Ryan--- -- RyGuy "yagna" wrote: Hi All, Could you please let me know how to increase the number precision in Excel workbook. I'm aware that the limit is 15,but unfortunately I have more than 16 number to type in a cell. for eg: 1234567891234565 this number will turnout to be 1234567891234560 could you please help on this excluding writing in text format. thanks in advance, yagna |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Precision
You need an add-in, for example:
http://precisioncalc.com/Free.html -- Gary''s Student - gsnu200775 "yagna" wrote: Hi All, Could you please let me know how to increase the number precision in Excel workbook. I'm aware that the limit is 15,but unfortunately I have more than 16 number to type in a cell. for eg: 1234567891234565 this number will turnout to be 1234567891234560 could you please help on this excluding writing in text format. thanks in advance, yagna |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Precision
In message , yagna
writes Hi All, Could you please let me know how to increase the number precision in Excel workbook. I'm aware that the limit is 15,but unfortunately I have more than 16 number to type in a cell. for eg: 1234567891234565 this number will turnout to be 1234567891234560 could you please help on this excluding writing in text format. Are you sure that text strings will not do the job? You are hitting a limitation of 8 byte IEEE floating point numbers that Excel uses as its default storage format. Your options are very limited. Namely to implement a high precision number package using strings, long integers or packed decimal or perhaps find an Excel clone that uses 10 byte temporary reals (most of these only gain you a couple more digits). MS withdrew support for 10 byte temporary reals in their compilers several versions ago so you are basically stuck with what Excel chooses to offer. Regards, -- Martin Brown -- Posted via a free Usenet account from http://www.teranews.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number precision | Excel Discussion (Misc queries) | |||
Number precision | Excel Discussion (Misc queries) | |||
Precision displayed does not match precision in cell | Excel Discussion (Misc queries) | |||
Number precision problem | Excel Programming | |||
32,767 Significant Digits of Precision, with Number Formatting | Excel Programming |