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.