2 Replies Latest reply: Nov 11, 2013 4:13 AM by Hans kleijnen RSS

    convert neg number

    Hans kleijnen

      Hi all,

      I want to upload a txt file, in which negative numbers are formatted as 1,111.11-.

      QV does not recognize this as a number at all.

      My attempt was in script to use (AmountDC,'#,##0.0;#,##0.0-') in the script. That one only results in error message and a total disappearing of the numbers.

      Who knows what to do?