Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
silvron
 
Posts: n/a
Default linked cell is displaying formula instead of the data

when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not the
origin cell data.
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Sounds like the cell is formatted as TEXT instead of GENERAL.
************
Anne Troy
www.OfficeArticles.com

"silvron" wrote in message
...
when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not
the
origin cell data.



  #3   Report Post  
silvron
 
Posts: n/a
Default

that was it, thank you very much...

"Anne Troy" wrote:

Sounds like the cell is formatted as TEXT instead of GENERAL.
************
Anne Troy
www.OfficeArticles.com

"silvron" wrote in message
...
when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not
the
origin cell data.




Reply
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
Displaying in a cell the formula from another cell Arjan Excel Discussion (Misc queries) 1 July 21st 05 07:17 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
numbers being entered show in formula bar but not in cell? Jim in Florida Excel Discussion (Misc queries) 2 May 13th 05 06:36 PM
Formula linked to cell with Macro Beginner Excel Worksheet Functions 0 March 30th 05 10:51 PM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM


All times are GMT +1. The time now is 01:39 AM.

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"