View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default How to Hide Negative Numbers

Hello,

I have a formula in Column C which subtracts a number in the previous sheet
plust a number in the current sheet. When I copy the formula I get negative
numbers because some of the cells in the current sheet are not yet populated.


Is there a way to hide the negatives numbers displaying in the column and
have the results show up once I populate the numbers in the cells the formula
is using?

Thanks,