I am stuck needed some help Asap, any leads would be appreciated
i have say some negative values say -65767.98, -876456.98, -764764.88 etc.
when pasting to excel i want them in parentheses for ex. : (65767.98),(876456.98) etc.
for this i am using like,
amount = -65767.98
FormatNumber(amount,UseParensForNegativeNumbers:=Tristate.True)
but when checking in mesg box it isgiving value with parentheses but when pasting to excel i cannot see parantheses only the negative values is present , like -65767.98 instead of (65767.98) . can anybody help please.
Hi , Thanks for the reply, but this will add brackets but would not retain the negative value of the number as moving forward i have to do some calculations on this value also.
From uipath - You can have anything - It basically depends on the column type you have in Excel .For the above results 2 columns are of type Text as shown below.