jnix try this:
under format there are 4 possible choices positive, negative, zero, and null enter each choice as you would like. For currency try this:
$#,###.##;($#,###.##);$0.00;$0.00
This would be your format for all 4 types: positive, negative, zero, and null. To replace the zero with blanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.