| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
link
I am setting up a link. The souce cell is blank, but the destination cell
reads"0". How do I keep it blank? |
|
#2
|
|||
|
|||
|
try
=if(source cell="","",source cell) "Greg" wrote: I am setting up a link. The souce cell is blank, but the destination cell reads"0". How do I keep it blank? |
|
#3
|
|||
|
|||
|
You can set a custom format so 0 will not appear at all. The value will not
change just the appearance. Click "Format", choose "Cells", on the "Number" tab find "Custom". Type the following as one possible choice: 0_);-0_);;@ "Greg" wrote: I am setting up a link. The souce cell is blank, but the destination cell reads"0". How do I keep it blank? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing automatic link | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Past Link then copy | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
