MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Blanks or zeros


Posted by Andy on December 05, 2001 4:27 AM

I have a master spreadsheet that contains links to several other data spreadsheets. Cells on the master spreadsheet that are linked to blank cells on the data spreadsheet show as zeros. Cells on the master spreadsheet that link to zero cells on the data spreadsheet also show as being zero on the master spreadsheet.

Is there any way to differentiate between the zero's and blanks on the master spreadsheet?


Posted by Hodge on December 05, 2001 5:42 AM

You could use something like . . .
IF(ISBLANK(A1), "", A1)

Posted by Mark W. on December 05, 2001 2:46 PM

Select all of the blanks on the master spreadsheet
use Edit | Go To... | Special Blanks. Type ="" and
press Control+Enter.