Max decimal places

G

Guest

Does MS Excel have a maximum number decimal places. I know that I can format
up to 30 decimal places. (This is not a formatting question.) Is 30 the
default or are the decimal places infinite?
I am uploading a file to a database and want to set the field length on the
database to the maximum possible decimal places as long as its not infinite.
Thank You.
 
C

Chip Pearson

Excel only supports 15 significant digits. Anything beyond that
is no mans land.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Access stripping decimal places in query 1
Incorrect result for simple SUM formula 9
Decimal Place goes crazy when using the "&" Sign. 4
Sum of numbers with only two decimal places wrong 2
Convert 10 Decimal Places to 2 3
How to retain decimal zeroes? 5
Setting decimal place for each row in a column 1
Equations and Text in same Cell 2

Top