Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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?

Re: Blanks or zeros

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

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

Re: Blanks or zeros

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.