Hide the "0" and get the name from the cell Tab

[cryge]

I have a few questions:

Q1:
if there in a cell (A) are a formula that that get's informations from an other cell (B), and there presently are no informations in that cell (B), there will apear a "0" in cell (A). How do i avoid to have this "0" ???

Q2:
if i want a cell to show the name of the sheet tab, what formula do i use?

Thanks
Christian

[Mikeopolo]

To hide all zeroes, go to Tools, Options, and untick the zeroes option on the first tab.

Don't know a function that will help, might require a custom function with some VBA code.

Regards