View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
scottfoxall scottfoxall is offline
external usenet poster
 
Posts: 40
Default 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