| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
='DataEntry '!K29
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
='DataEntry '!K29
Try this:
Copy the cell and then go to sheet 1 and do Edit = Paste Special = select "values" and then click "OK". HFC-SC wrote: 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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
='DataEntry '!K29
Chris.. many thanks this works.
"Chris" wrote: Try this: Copy the cell and then go to sheet 1 and do Edit = Paste Special = select "values" and then click "OK". HFC-SC wrote: 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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
='DataEntry '!K29
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 On Wed, 9 Aug 2006 12:29:02 -0700, HFC-SC wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
