='DataEntry '!K29

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?
>
>

's Computer Specifications

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 <HFC-(E-Mail Removed)>
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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DataEntry = True	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access Form Coding	8	25th Aug 2007 01:38 PM
dataentry using a datagrid	farouqdin@hotmail.com	Microsoft VB .NET	1	17th Jul 2007 10:57 PM
Help with dataentry errors	=?Utf-8?B?VkIgQ2hhbGxlbmdlZA==?=	Microsoft Access Form Coding	2	14th Sep 2006 08:56 PM
dataentry via forms???	eric iannuccilli	Microsoft Excel Misc	1	9th Sep 2004 07:30 PM
SubForm - DataEntry Only	Lisa B.	Microsoft Access Form Coding	0	7th Jul 2003 03:16 PM