PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Excel 2003

Reply

Excel 2003
 
Thread Tools Rate Thread
Old 14-06-2007, 01:38 PM   #1
=?Utf-8?B?Sm9oYW4=?=
Guest
 
Posts: n/a
Default Excel 2003


I have enetered a link to another worksheet cell, say in cell C2: =Sheet2!A1.
The result in C2 indicates the formula (=A1) and not the answer of A1. Note
that all the other cells in the worksheet has formulas and return the answers
and the Tool/Options/View/Formulas tab is unticked
  Reply With Quote
Old 15-06-2007, 10:28 AM   #2
=?Utf-8?B?TWlrZSBI?=
Guest
 
Posts: n/a
Default RE: Excel 2003
The cell is probably formatted as text. delete the formula, format as general
and re-enter the formula.

Mike

"Johan" wrote:

> I have enetered a link to another worksheet cell, say in cell C2: =Sheet2!A1.
> The result in C2 indicates the formula (=A1) and not the answer of A1. Note
> that all the other cells in the worksheet has formulas and return the answers
> and the Tool/Options/View/Formulas tab is unticked
  Reply With Quote
Old 15-06-2007, 10:59 AM   #3
=?Utf-8?B?Sm9oYW4=?=
Guest
 
Posts: n/a
Default RE: Excel 2003
100% fixed - thank you, Mike

"Mike H" wrote:

> The cell is probably formatted as text. delete the formula, format as general
> and re-enter the formula.
>
> Mike
>
> "Johan" wrote:
>
> > I have enetered a link to another worksheet cell, say in cell C2: =Sheet2!A1.
> > The result in C2 indicates the formula (=A1) and not the answer of A1. Note
> > that all the other cells in the worksheet has formulas and return the answers
> > and the Tool/Options/View/Formulas tab is unticked
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off