Say we have data in A1 thru B30 like:

3 0
0 0
3 3
3 2
3 3
2 2
2 1
0 1
1 0
3 2
3 2
2 3
3 1
2 2
1 0
2 3
2 3
3 0
3 2
3 0
3 1
3 2
3 2
1 0
3 3
0 0
0 0
0 1
0 1
3 1

enter and run this small macro:


Sub NothingAtAll()
Dim r As Range, rr As Range
Set r = Range("A1:B30")
For Each rr In r
If rr.Value = 0 Then
rr.Value = ""
End If
Next
End Sub

and the result:

3

3 3
3 2
3 3
2 2
2 1
1
1
3 2
3 2
2 3
3 1
2 2
1
2 3
2 3
3
3 2
3
3 1
3 2
3 2
1
3 3


1
1
3 1

--
Gary''s Student - gsnu200908


"kepetersen3405" wrote:

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.