[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
Or use a custom number format similar to this...
[Black][0.001]$#,##0.00;[Red][<-0.001]($#,##0.00);[Blue]$0.00;[Green]"(CHECK DATA)"
--
Jim Cone
Portland, Oregon USA
"Jim Cone"
wrote in message
Both -0.000001 and 0.000001 will display as 0.00 but neither are zero.
You probably need to round the cell value.
--
Jim Cone
Portland, Oregon USA
|