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

Number format output

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

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

Output

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

Thanks.

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

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