| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need linked cell to be blank not 0
I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently it shows zero (0). How di I make it blank? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| Results from blank linked cells | New Users to Excel | |||
| do not chart cells linked from worksheets that are blank | Charts and Charting in Excel | |||
| Why does linked data from blank cells become a zero? | Excel Discussion (Misc queries) | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Threaded Mode
