Prev Previous Post   Next Post Next
  #1   Report Post  
Freshman
 
Posts: n/a
Default Paste Link

Dear all,

In a workbook, Sheet 1, cell A1, the value is "". I try to link the cell
value to Sheet 2, also cell A1. However, after I paste link the cell, the
value appears in Sheet 2, cell A1 is "0" instead of "". What should I do with
the paste link so that both the source cell and pasted cell are also equal to
"". It is because I want both cells are equal to "" at the very beginning.

Thanks in advance.
 
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
paste formulas between workbooks without workbook link ron Excel Discussion (Misc queries) 3 April 22nd 23 08:11 AM
Paste Link - retaining formatting Suzanne Marie Excel Discussion (Misc queries) 1 August 18th 05 02:02 AM
In Excel: Paste Special should have a "Link Value" Selection Deon Isis Excel Worksheet Functions 0 June 30th 05 02:12 PM
"paste special" "paste link" lssweatt Excel Discussion (Misc queries) 2 March 29th 05 08:51 PM
Paste Link enters a 0 into the cell where I paste. How do I elemin UNR Excel Discussion (Misc queries) 4 March 28th 05 01:54 AM


All times are GMT +1. The time now is 10:14 PM.

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

About Us

"It's about Microsoft Excel"