exponent value

Discussion in 'Questions (Windows Mobile)' started by kavka, Jan 15, 2008.

  1. kavka

    kavka Member Licensed User


    I have a little problem. Data is in the CSV file. Because I want to sort data in the table according to date I have a dateticks row. Because some of this values are written normally (86738827000000000) and others in the exponent form (8.673882E+17) the program does not arrange these data in the correct order.
    Question: how do I force the data to be written in the normal way (non exponent)?

    THX Kavka
  2. Erel

    Erel Administrator Staff Member Licensed User

    You should use the Format keyword:
    a = Format(now * 10,"n0")
    It will add commas to the number but it should not bother you.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice