Results 1 to 2 of 2

Thread: Double data type field's value showing with E-02 value
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2009
    Posts
    425
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Double data type field's value showing with E-02 value

    Hi,

    I have data in excel and one field in excel value is showing like (0.0816901332227654), and when I paste this data in a Access table the data is showing is like this (8.16901332227654E-02), the number should show in Access as showing in Excel.

    I don't know how can I fix it, pleas help me resolve this problem.

    Thanks
    Kashif

  2. #2
    Board Regular jmacleary's Avatar
    Join Date
    Oct 2015
    Location
    at a desk in the UK
    Posts
    525
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Double data type field's value showing with E-02 value

    It sounds like the format property of the field in Access is set to Scientific. Try setting it to General.
    If my answer has helped, please vote using the Thanks or Like buttons on the left.
    John

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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