Number of Decimals Excel can Handle

  • Thread starter Nicolas Cachanosky
  • Start date
N

Nicolas Cachanosky

I would like to know how many numbers of decimals the latest versions of
Excel can handle (2003 and 2007)

Any help on how to find this data will be appreciated.

Kind Rgds.
 
N

Niek Otten

In Excel Help: Specifications, Calculation

This tells you the precision is 15 decimal digits.

But you should know how to interpret that; 0.0000000000000123456789012345 is still possible.

Look here for more info:

http://support.microsoft.com/kb/78113

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to know how many numbers of decimals the latest versions of
| Excel can handle (2003 and 2007)
|
| Any help on how to find this data will be appreciated.
|
| Kind Rgds.
| --
| Nicolas Cachanosky
 

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

Top