| || |
I need to convert a value which is displayed with a negative number to parenthesis.
Lets say for example X = -5,600,001 I need it to be displayed as (5,600,001). Below is the code I tried using for this but having issues.
Calval3 = (FormatNumber(Calval3,,,-1)
Re: Using UseParensForNegativeNumbers
I tried what you have in QTP and get
Calval3 = "(5,600,001.00)"
what is the result you want is it "(5,600,001)" ? if so just throw a 0 after the first comma
Calval3 = (FormatNumber(Calval3,0,,-1))