Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making cells show nothing
I have a master workbook that I use to compile entries from about 25 different individual's workbooks. I have a page for each person set up and was just using a formula "=[workbook_name]sheet_name!cell_reference"(i.e. ='[Auditor Savings Jan 06.xls]Audits'!$A$29). As the month goes on, each individual creates entries and those lines are fine. My problem is that a line that does not yet have data entered is showing up on my master as either "0" or 1/0/00. Is there a way to have the master page just show as blank when the data page doesn't have anything entered yet? I tried using conditional formatting (if cell is equal to 0), but that didn't do anything. Any suggestions? -- kimmer4861 ------------------------------------------------------------------------ kimmer4861's Profile: http://www.excelforum.com/member.php...o&userid=30755 View this thread: http://www.excelforum.com/showthread...hreadid=504221 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells show wrong number | Links and Linking in Excel | |||
Merge cells in Excel 2003 doesn't show up on Format Alignment | Excel Discussion (Misc queries) | |||
Show the contents of certain cells if.... | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions |