View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Negative result gives #### is there a way to show the actual - num

Post the formula and a description of the data the formula is manipulatiing
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"catts22" wrote:

Hi

The result of a formula gives me ##### for a negative number. Is there a
way to get the actual negative number (i.e. for example -9 instead of ###)?

Alternatively maybe show a 0 (zero)? Sending a report to my boss with ####
doesn't look so great. Maybe a minimum number formula?

Thanks