Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2006
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing numbers from CSV (Excel XP)

    I am opening .CSV file with Excel that contains some large numbers. The numbers automatically get converted to floating points because they are 15 digits long. Excel formats the cells as Scientific with 2 decimals. How do I prevent this from happening?
    Here is an example of how the large numbers appear.
    8.25E+13
    3.32E+14
    8.60E+13
    8.37E+13

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing numbers from CSV (Excel XP)

    Try formatting the column as Number with 0 decimal places. Make the column wide enough.

Posting Permissions

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