+ Reply to Thread
Results 1 to 3 of 3

9200000000000009 display incorrectly.

  1. #1
    Summer
    Guest

    9200000000000009 display incorrectly.

    I input 9200000000000009 into Excel, but display to 9200000000000000, the
    latest digit is incorrectly.

  2. #2
    Guest

    Re: 9200000000000009 display incorrectly.

    Hi

    When formatted as a number (or General) Excel only displays to 15 digits. If
    you wish to use more than that you'll have to format the cell as text before
    you type into it, or precede your entry with a '

    Hope this helps
    Andy.

    "Summer" <[email protected]> wrote in message
    news:[email protected]...
    >I input 9200000000000009 into Excel, but display to 9200000000000000, the
    > latest digit is incorrectly.




  3. #3
    Summer
    Guest

    Re: 9200000000000009 display incorrectly.

    Thanks a lot. It works.

    "Andy" wrote:

    > Hi
    >
    > When formatted as a number (or General) Excel only displays to 15 digits. If
    > you wish to use more than that you'll have to format the cell as text before
    > you type into it, or precede your entry with a '
    >
    > Hope this helps
    > Andy.
    >
    > "Summer" <[email protected]> wrote in message
    > news:[email protected]...
    > >I input 9200000000000009 into Excel, but display to 9200000000000000, the
    > > latest digit is incorrectly.

    >
    >
    >


+ 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