Why not just elect in advanced options to NOT show zeros for the workbook?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, July 12, 2012 5:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Remove 0 from Whole
Thanks Guru jee its great!
On Thu, Jul 12, 2012 at 4:25 PM, NOORAIN ANSARI wrote:
> Dear Group,
>
> Please find attached screen shot, We can remove 0 from whole workbook
> without using any function or any Macro.
>
> See technique and revert.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noor