Thanks Jim for your immediate response. But I found another way.
Go to ToolsOptionsViewZero Values and untick the box.

But I don't know if it works when the cell shows error values

"Jim Cone" wrote:


Change your formulas so they return "" instead of zeros or error values.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Aravind"
wrote in message
While printing a excel sheet I do not want cells containing formulas printing
zeroes or any other characters like error values, it should print just empty.