Convert negative values to value with parentheses

Help
, , , ,
1

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 !!

2

hi @Shikhar_Tandon,

Alternative :

UIpath Code

image
image1130×390 10.1 KB

Result in Excel :
image

–
Mukesh

3

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
!!

4

image

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

–
Mukesh

5

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

6

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

Thanks

7

Hi @Shikhar_Tandon,

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

8

hi @Shikhar_Tandon,

I Tried with 3 Samples as shown below

image
image1136×508 12.6 KB

These are the Outputs.

image
image849×217 1.96 KB

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.

image

–
Mukesh