Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Yes, that was a zero, sorry.
"Richard Buttrey" wrote: On Fri, 9 Sep 2005 09:41:05 -0700, "Steve" wrote: Good day. I have a spreadsheet linking back to another spreadsheet. The link is working just fine, unless there is no data in the original cell, causing a "0" to show up in the linked cell. Is there any way, other than an if then statement to get rid of the "O" showing up in the linked cell. Thanks, Is this a letter "O" or zero. if it's zero you could set the sheet to not display zero values. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
linking cells and assort decending | Excel Discussion (Misc queries) | |||
Excel - linking cells | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Linking Non-Contiguous cells | Excel Discussion (Misc queries) |