Number Precision

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yagna - 25 Mar 2008 15:38 GMT

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

Reply to this Message

ryguy7272 - 25 Mar 2008 15:45 GMT

Hope This Helps:
http://www.cpearson.com/excel/rounding.htm

Regards,
Ryan---

Signature

RyGuy

> Hi All,
>
[quoted text clipped - 8 lines]
> thanks in advance,
> yagna

Reply to this Message

Gary''s Student - 25 Mar 2008 15:46 GMT

You need an add-in, for example:

http://precisioncalc.com/Free.html

Signature

Gary''s Student - gsnu200775

> Hi All,
>
[quoted text clipped - 8 lines]
> thanks in advance,
> yagna

Reply to this Message

Martin Brown - 25 Mar 2008 16:01 GMT

>Hi All,
>
[quoted text clipped - 5 lines]
>
>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,

Signature

Martin Brown

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message