Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Virginia
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing long numbers from Excel (2000)

    I'm having problems importing a number from Excel which is 13 digits long into Access. When the cell is imported, Access displays the number with a decimal point and extra numbers. For example, in Excel, the number is 6830013778183 and when it is imported into Access turns into 6.830013778183E+12. How do I get Access to show the number as in Excel?

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

    Re: Importing long numbers from Excel (2000)

    Set the Format property for the field containing the number to Fixed, and the Decimal Places property to 0.

    By the way, the default display (number format set to General) in Excel is 6.83001E12; you have to set the number format to Number with 0 decimal places to see 6830013778183. So the behavior of Access and Excel is not very different in this respect.

Posting Permissions

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