I’m working on a spreadhseet with mutiple sheets in the workbook.
The first sheet is just 1 column long where you enter names and it propogates to the other pages. On the other pages I am using the following code =Names!A3 for the first name =Names!A4 for the second etc. I have the type set to text for formatting but it displays a 0 for any blank line. How do I make it display nothing if there is no name?
Here’s one way
=IF(ISBLANK(Names!A1),"",Names!A1)
Russell
Alternate method to hide the zero in just a single cell (or a selected set of cells:
Select the cells that contain zeros (0’s) or other values that you want to hide.
On the Format menu, click Cells, and then click the Number tab.
In the Category box, click Custom.
To hide zero values, type 0;-0;;@ in the Type box.
Or, to hide the zeros throughout the entire worksheet:
On the Tools menu, click Options, and then click the View tab.
To display zero (0) values in cells, select the Zero values check box.
To display zero values as blank cells, clear the check box.