#,###0.00

[lezawang]

Hi
I am trying to understand why 0.00 is used for in that format. Is it for 0s? If that is the case then why we have positive;negative;zero;text?

instead we should have format like this

#,###.00; #,###.00; 0.00; @WHATEVER

Thanks

 

[MARK858]

What happens if you put .9 in a cell with both formats?