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

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