Number format output

[raj8257]

Hi, I want to format the numerical output (Output currently into Excel) as follows:

currently		required
-12.4		(12.40)
-1.49		(1.49)
-120		(120.00)
15		15.00
41		41.00
40		40.00
1189.8		1,189.80

Ideally wanted to have all values to be lined up (ie even with brackets for negatives).

Also, is there a way of having negative values in red font?

Many thanks

[ImadZidan]

Hello @raj8257 ,

Here is an idea with regards to the number format.

As for the alignment and the red color, are you creating a report?

I hope this helps

[raj8257]

Hi, thanks for the reply. Yes I'm creating an Excel report using the Output Data tool 

[grazitti_sapna · Accepted solution]

Hi @raj8257 , I have updated @ImadZidan workflow you can try this and can use render tool to output the result into excel file. 

Thanks.