+ Reply to Thread
Results 1 to 2 of 2

Max decimal places

  1. #1
    SusieQ
    Guest

    Max decimal places

    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.

  2. #2
    Chip Pearson
    Guest

    Re: Max decimal places

    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


    "SusieQ" <SusieQ@discussions.microsoft.com> wrote in message
    news:662E097D-1981-43C9-96B5-DFDFD57775A4@microsoft.com...
    > 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.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1