Format for displaying negative numbers in ()

[sonikajain]

Hi all,

In one of my requirements, I need to display negative numbers in brackets for  specific rows. I am using 'IF ' for this in expressions and the num () function - with format '#.#%;(#.#%), but it is giving me discrepnacies in result as in -

for Num (-1.4,'#.#%;(#.#%)')   result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%

Please help me on this.

Sonika

[sonikajain]

for Num (-1.4,'#.#%;(#.#%)')   result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%

[Nicole-Smith]

Num (1.4,'#.#;(#.#)') &'%'

[CELAMBARASAN]

Hi,

     You should use like this

     =Num (1.4/100,'#.#%;(#.#)%')

or

     =Num (1.4/100,'#.#;(#.#)')&'%'

[#5]

Hi,

In the Properties Tab of the chart,

Goto Number Tab,sleect the expression

goto Fixed to and paste the below format in the format pattern.

#.##0,00; (#.##0,00)

Regards,

Snehal Nabar