ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number precision (https://www.excelbanter.com/excel-discussion-misc-queries/87137-number-precision.html)

Jake

Number precision
 
Hello,
Is there any way for Excel to exceed the limit of 15 digits i.e. 2^64?
Other than displaying the number as text.
Thanks!
Jake



Gary''s Student

Number precision
 
Check Google for high=precision Excel add-ins
--
Gary's Student


"Jake" wrote:

Hello,
Is there any way for Excel to exceed the limit of 15 digits i.e. 2^64?
Other than displaying the number as text.
Thanks!
Jake




atmbonda

Number precision
 
Did you try
-Format
-Cells
- Number
- Decimal places (enter for instance 20 for 20 decimal places)

Thanks

"Jake" wrote:

Hello,
Is there any way for Excel to exceed the limit of 15 digits i.e. 2^64?
Other than displaying the number as text.
Thanks!
Jake





All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com