Max decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Decimal Place goes crazy when using the "&" Sign. 4
More than two decimal places 1
Sum of numbers with only two decimal places wrong 2
How to retain decimal zeroes? 5
Decimal point in bar chart and similar 1
Incorrect result for simple SUM formula 9
formula for decimal point 4

Back
Top