Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    NH, US
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbers displayed as exponents

    Hi there,

    Having a bit of a problem with 16-digit number strings. These strings have no punctuation or separation--just 16 digits in a line. Excel wants to display them as exponents when the cells are formatted as general or text. If formatting is set to number with 0 decimal places or custom number (represented with a string of #'s) the cells show numbers but not necessarily the ones I want. The last digits are always converted to 0's by Excel--even when I want a 2 or something else.

    I'm pretty sure this has to do with number limitations in Excel and am searching for a work around, but coming up dry. Anyone out there have any ideas?

    Thanks!

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers displayed as exponents

    Can't you just add a quote ' in front? This should make clear to Excel that the things you enter are text.

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    NH, US
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers displayed as exponents

    That does the trick! Thanks.

Posting Permissions

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