Convert negative values to value with parentheses

Shikhar_Tandon · May 13, 2020, 3:56am

Hi Champs,

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.

Thanks !!

mukeshkala · May 13, 2020, 4:28am

hi @Shikhar_Tandon,

Alternative :

UIpath Code

Result in Excel :

–
Mukesh

Shikhar_Tandon · May 13, 2020, 4:32am

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.

Thanks
!!

mukeshkala · May 13, 2020, 4:34am

How do you want to have the value in excel ? anything from above screenshot

–
Mukesh

jhj3627 · May 13, 2020, 4:38am

Hi.
You can use ‘replace’.
text=text.replace("-","")

Shikhar_Tandon · May 13, 2020, 4:47am

Should be (123456) when we convert a negative value to a value with parantheses it automatically turns red also .

Thanks

samir · May 13, 2020, 5:05am

Hi @Shikhar_Tandon,

You can concatenate parentheses to its both end with replacing - with null like this,
"("+Number.ToString.Replace("-","")+")"

mukeshkala · May 13, 2020, 5:10am

hi @Shikhar_Tandon,

I Tried with 3 Samples as shown below

These are the Outputs.

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.

–
Mukesh