| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking to other workbooks
I am linking cells from one worksheet to another. When there is nothing
entered yet in the worksheet that I want the into to carry over from, it is inserting a 0 in the cell (but shows my formula in the top fx box). Do you know how to get rid of that 0 so the cell is completely blank until the info is entered on the worksheet it is linked to? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking to other workbooks
=IF(Sheet1!A1="","",Sheet1!A1)
Will make the cell look blank. Gord Dibben MS Excel MVP On Wed, 20 Jun 2007 13:05:38 -0700, Bouket wrote: I am linking cells from one worksheet to another. When there is nothing entered yet in the worksheet that I want the into to carry over from, it is inserting a 0 in the cell (but shows my formula in the top fx box). Do you know how to get rid of that 0 so the cell is completely blank until the info is entered on the worksheet it is linked to? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking workbooks | New Users to Excel | |||
| linking workbooks | Excel Discussion (Misc queries) | |||
| linking workbooks | Excel Worksheet Functions | |||
| Linking workbooks | Excel Worksheet Functions | |||
| Linking Workbooks | Excel Worksheet Functions | |||
Linear Mode
