Number Formatting in XLS

[awood69]

I need to be able to use the same style for multiple number formats. For example, I need to show anywhere between 0 & 2 decimal places. I have this like below -

<NumberFormat ss:Format="#,###.##;[Red]\(-#,###.##\)"/>

Problem is I get the following results and I need to not show the decimal.


37 - 37.

Please Help.

 

[Andrzejek]

Try:

<NumberFormat ss:Format="#,##[blue]0[/blue].##;[Red]\(-#,##[blue]0[/blue].##\)"/>

Have fun.

---- Andy

 

[awood69]

Andy, thanks for the response but that will still show the decimal.