is there way to prevent cells from rounding large numbers?

[iknowu99]

1,111,111,111,111,112.00
why do the units round to zero for this number?

 

[Aladin Akyurek]

See Excel specs below in the second row...

Feature	Maximum limit
Number precision	15 digits
Smallest allowed negative number	-2.2251E-308
Smallest allowed positive number	2.2251E-308
Largest allowed positive number	9.99999999999999E+307
Largest allowed negative number	-9.99999999999999E+307
Largest allowed positive number via formula	1.7976931348623158e+308
Largest allowed negative number via formula	-1.7976931348623158e+308
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Worksheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Number of available worksheet functions	341
Size of the operand stack	1,024
Cross-worksheet dependency	64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency	Limited by available memory
Area dependency	Limited by available memory
Area dependency per worksheet	Limited by available memory
Dependency on a single cell	4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks	32,767
Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation	December 31, 9999
Largest amount of time that can be entered	9999:59:59

<tbody>
</tbody>

 

[Macropod]

Excel has a precision limit of 15 digits. Anything more than that gets rounded down to 0 and the 15th digit gets rounded off.

 

[iknowu99]

I did see that but didn't know what it was. How about the fact that the largest number can go to 10E307? Wouldn't it be possible to write vba to concatenate strings and increase precision on ad hoc basis?

 

[Aladin Akyurek]

I did see that but didn't know what it was. How about the fact that the largest number can go to 10E307? Wouldn't it be possible to write vba to concatenate strings and increase precision on ad hoc basis?

If no math is done on such numbers, you can switch to text numbers.

 

[mikerickson]

And one can (I have) written routines to do basic arithmetic on numerals (strings) of indefinite length.

They get kind of slow though.

 

[iknowu99]

=2^49 excel returns correctly (562,949,953,421,312) but 2^50 the units get rounded: 1,125,899,906,842,620. Was there a way to Reference open-source such as Python engine (it seems to be able to handle such calculations). For example how would one develop something similar to the vba property that calls excel functions "WorksheetFunction.*" but instead "PythonFunction.*"

 

[B___P]

Hi iknowyou,

Search for Xnumbers on the internet.

bye

 

[Rick Rothstein]

=2^49 excel returns correctly (562,949,953,421,312) but 2^50 the units get rounded: 1,125,899,906,842,620. Was there a way to Reference open-source such as Python engine (it seems to be able to handle such calculations). For example how would one develop something similar to the vba property that calls excel functions "WorksheetFunction.*" but instead "PythonFunction.*"

Your first message seems to indicate that you put that number in a cell (hence the limit to 15 significant digits) whereas in the above message you seem to be referring to output from VB code (printed to the Immediate Window is my guess). The Excel world and the VBA world are two semi-independent worlds with their own limitations and display limits. Which world are you ultimately interested in working in?