LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Steve
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you "select locked cells" w/o "select unlocked cells"? princejohnpaulfin Excel Discussion (Misc queries) 3 July 16th 05 03:53 AM
linking cells and assort decending Cindy Morgan Excel Discussion (Misc queries) 0 July 8th 05 12:39 AM
Excel - linking cells Cyndi Excel Worksheet Functions 1 July 6th 05 08:26 PM
Fill cells from non-adjacent cells Abes Excel Discussion (Misc queries) 2 March 25th 05 01:15 PM
Linking Non-Contiguous cells Mike A Excel Discussion (Misc queries) 0 December 7th 04 03:47 AM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"