A version of excel that doesn't have 15 limitation

  • Thread starter Thread starter Guest
  • Start date Start date
Kimjo

What are you trying to do that needs more than 15 digits?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
15 digits is the standard for IEEE representation of floating point numbers.
Why do you need more?
 
For credit card numbers, etc., use text (preceed the digits with a
single quote). Otherwise Excel and almost all other general purpose
software uses IEEE double precision math.

Jerry
 
You must log in or register to reply here.

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

Vlookup with more than 15 digits 2
How to save a 15 digit # in CSV without it changing to a formula? 1
Making a Sheet copy 3
First 2023 ? From the frozen wastes of Wisconsin nowadays, but originally from the sophisticated part of Yorkshire....(Chuckle). 4
INT defect: Please try this on 2007 for me 26
Excel How to calculate in excel number of open actions that expired (older then today) 0
EXCEL - IF(IFERROR(VLOOKUP question 0
more than 15 numbers in a cell? 7

Back
Top