If you're not already using a specific format such as
Date/Time/Currency.....

Format the cells as CUSTOM 0;-0;;@

Or, use conditional formatting. It would be more efficient than doubling up
on the formula.

Using either of the above, just be aware that the 0's are still in the
cells. You just can't see them.

Biff

"Max" wrote in message
...
"TUNGANA KURMA RAJU" wrote:
Thanks Mr.Max, its working fine.

Glad it worked ! (Go easy, pl drop the "Mr" bit <g)

Is there any other way to switchoff display of zero values? ..

We could use an IF construct:
=IF(OFFSET(..)=0,"",OFFSET(..))
to return blanks: "" if the OFFSET returns a zero
(but at an increase to the calc load, of course)

Put instead in M1, and fill across/down:
=IF(OFFSET(INDIRECT("'"&$A$1&"'!A1"),ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)=0,"
",OFFSET(INDIRECT("'"&$A$1&"'!A1"),ROWS($A$1:A 1)-1,COLUMNS($A$1:A1)-1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---