capacity of number in excel

[MyExcel]

hi
what is the capacity of excel with number
and wht excel add zero after a big number
and how i can write number from 35 digits without convert it to zero

 

[pgc01]

Hi

Your problem is not the maximum number excel can deal with, it's how many significant digits you can have.

In the worksheet you can have numbers with a maximum of 15 significant digits. If you enter more digits, excel will not get them, they will be lost and converted to zero.

To have numbers with more significant digits enter them as text. Either format the cell as text and enter the number, or preceed the number with a single quote.

 

[MyExcel]

thanx pgc01
but when i define the number as text i can't make any math operation on it
how i can make divide or multiply and the result may be number with digits more than the original number

 

[pgc01]

You cannot perform operations with such big numbers directly in excel using native operations/tools.

You have 2 options:

- you write the code to perform such operations

- you use code written by someone else, like buy a library of BigNum functions. Search the web, there may even be free code that you can copy and adapt

HTH

 

[MyExcel]

i am sorry
i can't get any thing from internet

 

[pgc01]

I found this one:

http://digilander.libero.it/foxes/MultiPrecision.htm

seems promising, with a maximum of 250 significant digits should deal with your 35 digit numbers with no problem.

 

[mikerickson]

This will handle unlimited number of digits.
http://www.ozgrid.com/forum/showthread.php?t=78323