sum more than 15 digts

[mazdak]

hi all


how can i use more than 15 digts in mat ?

<TABLE style="WIDTH: 287pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=382 x:str><COLGROUP><COL style="WIDTH: 287pt; mso-width-source: userset; mso-width-alt: 13970" width=382><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 287pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl24 height=17 width=382 align=right x:num="1.23456789012345E+20">

a1=123,456,789,012,345,000,000​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl24 height=17 align=right x:num="1.2345678901234499E+17">

b1=123,456,789,012,345,000​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl24 height=17 align=right x:num="1.2358024580135734E+20" x:fmla="=SUM(A1:A2)">

=sum(a1+a2)123,580,245,801,357,000,000

​

</TD></TR></TBODY></TABLE>​

 

[Domski]

Format the cells as Number and you should get the correct result I think.

Dom

 

[Richard Schollar]

You should be able to sum them - you just won't have any precision beyond the 15 digits.

 

[mazdak]

You should be able to sum them - you just won't have any precision beyond the 15 digits.

mazdakkazemzadeh@yahoo.com

 

[ScottR]

You can try this http://precisioncalc.com/index.html

But I haven't used it and am not vouching for it.