='DataEntry '!K29

H

HFC-SC

I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the
formula not the text. Help please?
 
C

Chris

Try this:

Copy the cell and then go to sheet 1 and do Edit => Paste Special =>
select "values" and then click "OK".
 
H

HFC-SC

Chris.. many thanks this works.

Chris said:
Try this:

Copy the cell and then go to sheet 1 and do Edit => Paste Special =>
select "values" and then click "OK".
Click to expand...
 
G

Gord Dibben

Perhaps the Sheet1 cell is formatted as text?

Re-format to General and re-enter the formula by F2 then Enter.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
VBA Coding Help for Beginner 0
Publisher adding blank page when printing my booklet... 2
Cell data entering slow! 0
Printer Page & Drawing Page 0
Continues to move to the right 0
Section and Page numbering 0

Top