| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying results in dollars
How can-I format a cell so that the result of an addition (in dollar format)
does not display $0.00 when the result is $0.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying results in dollars
Use a format like
$#,##0_);[Red]($#,##0);; As long as you have nothing between the second and third ';', zero values will not be displayed "Equation" wrote: How can-I format a cell so that the result of an addition (in dollar format) does not display $0.00 when the result is $0.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying results in dollars
You can do that with Conditionally Formatting.
Format - Conditionally Format - Cell value ... is equal to ... 0 - format - font - color - white. Value still stays there but is not at sight. "Equation" kirjoitti: How can-I format a cell so that the result of an addition (in dollar format) does not display $0.00 when the result is $0.00 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying results in dollars
You can also use Tools - Options, uncheck "zero values" under Window options.
"Equation" wrote: How can-I format a cell so that the result of an addition (in dollar format) does not display $0.00 when the result is $0.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula results not displaying | Excel Worksheet Functions | |||
| Displaying how many results in a vlookup | Excel Discussion (Misc queries) | |||
| Displaying formula rather than results... | Excel Discussion (Misc queries) | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
| displaying results and not formulas | Excel Worksheet Functions | |||
Linear Mode
