How to shift minus sign from right side to left side

[nehasaxena]

Hello,

There are minus signs are on right side in the excel file that I am receiving from database team.

For example - 1.333-

Please help me to fix this in Qlikview.

Thanks.

Neha

[Anonymous]

How it is interpreting '-' and '+' only ?

Why not others?

[A7R3]

I found out that this works.

=NUM#(Qty, '# ; #-') * 1