Combining number formats

[greenfortyguy]

Hello,

Is there a way I can combine the two number formats:

1. #,##0,;[Black](#,##0,)

and

2. 0;-0;;@

In order to get a formatting rule that rounds numbers to the nearest thousand, including the separating comma; puts negative numbers in brackets; and hides zero values?

Many thanks,

Guy

 

[mse330]

Try the below perhaps

#,###,;[Black](#,###,);@

 

[greenfortyguy]

Hi,

Thanks, that did the job!

 

[mse330]

Glad I could help & thanks for reporting back

I think this can also the trick

#,###,;[Black](#,###,) without the ;@