Hide negative numbers in Excel
You could hide the negative values with conditional formatting;
If the value is less than 0 then the text colour is white (assuming you have
a white backround)
DO:
Format conditional Formatting
then select is less than for cell value and enter 0
then click format and text colour as white.
Hope that helps
"James" wrote:
Hi I am working on real simple spreadsheet in Excel I have a little problem.
I do not want to show negative numbers. For my spread sheet a negative is
mute so it is not needed. Any way to hide them?
Thank you,
James
|