View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kepetersen3405 kepetersen3405 is offline
external usenet poster
 
Posts: 4
Default Converting 0 values to Blanks

I am using Microsoft 2003.

Is there a forumla that will force a zero value to be either null or blank?
I am taking a list from Excel and importing it into Business Objects and
creating a chart. If the value is zero, it creates a zero line on my graph.
If the value is blank, it doesn't display.

I've tried doing a forumla that says if the value is 0 return "" but that
doesn't work for what I want to do.