Hide or remove zero value and keep the text

[Former Member]

Hi gurus,

My client require the Balance sheet and Profit & loss  report which doesn't contain the zero value and keep the text and  format alive. when i have used the  emp option  remove empty and zero values  the whole format  changed. But my the format should change the while remove the zero vaule.

for example

	Note No	As at	As at
Particulars		Mar 2014	Mar 2013
		Rs.	Rs.
Equity and Liabilities(text)
Shareholders' Fund(text)
Share Capital		157,600,700.00
Reserve & Surplus		(5,056,744.30)
		152,543,955.70	-
Share Application Money Pending allotment(account memmber)
Minority Interest (account member)		157,600,700.00	-
Non-Current Liabilities(Text)
Long Term Borrowings		182,189,227.00
Deffered Tax Liabilities
Other Long Term Liabilities		78,865.00
Long Term Provisions
		339,868,792.00

Now Client required as.......

	Note No	As at	As at
Particulars		Mar 2014	Mar 2013
		Rs.	Rs.
Equity and Liabilities
Shareholders' Fund
Share Capital		157,600,700.00
Reserve & Surplus		(5,056,744.30)
		152,543,955.70
Minority Interest		157,600,700.00
Non-Current Liabilities
Long Term Borrowings		182,189,227.00
Other Long Term Liabilities		78,865.00
		182,268,092.00

Please provide the solutions.

Regards.

Surya.

[Former Member]

I have resolve the issue by using the vb code in excel.

Thaks.