12 Replies Latest reply: Aug 17, 2011 2:34 AM by Thanomjit Kiatchavanasawee RSS

    formatting number

    Tomas Hylander

      Ive got a couple of numbers ranging from 0.1 to 0.00001 in a excel-file. They are not formatted as numbers (due to the range).

      I dont  want the numbers to with a fixed format (0.10000 to 0.00001).

       

      How can I deal with this in QW?

      It works now with 4 decimals but with 5 it shows 4,6e-005 (0.00046).

       

      Thanks in advance!