Number precision

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

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
 
Did you try
-Format
-Cells
- Number
- Decimal places (enter for instance 20 for 20 decimal places)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum amount of numbers in one Cell 2
Number formats 5
Number precision 2
Significant Digits of Precision 3
formatting negative numbers 1
Custom number format #,##0.## yields extra '.' when formattingintegers 3
Limiting text entries 7
Importing Long Numbers as Text cells 1

Back
Top