Formula is entered but will not display result

This is elementary, I think, and I know it's happened to me before but I can't remember what the problem was. I have a simple formula:

='Different Worksheet'!$R13

The formula is copied on several worksheets, and I need to go through and update the row number. It displays the result of the above until I change the row number, and then it displays the actual formula instead of the result. Any idea why it won't pull the result??

Perplexed,
Amy

1. clear the cell
2. format the cell as general (not text)
3. re-type the formula (not paste)

Excel may be treating your formula as a text string.
--
Gary''s Student


"webee33" wrote:

>
> This is elementary, I think, and I know it's happened to me before but I
> can't remember what the problem was. I have a simple formula:
>
> ='Different Worksheet'!$R13
>
> The formula is copied on several worksheets, and I need to go through
> and update the row number. It displays the result of the above until I
> change the row number, and then it displays the actual formula instead
> of the result. Any idea why it won't pull the result??
>
> Perplexed,
> Amy
>
>
> --
> webee33
> ------------------------------------------------------------------------
> webee33's Profile: http://www.excelforum.com/member.php...o&userid=28171
> View this thread: http://www.excelforum.com/showthread...hreadid=476983
>
>

make sure that the cell isnt formatted as text.
--
paul
remove nospam for email addy!



"webee33" wrote:

>
> This is elementary, I think, and I know it's happened to me before but I
> can't remember what the problem was. I have a simple formula:
>
> ='Different Worksheet'!$R13
>
> The formula is copied on several worksheets, and I need to go through
> and update the row number. It displays the result of the above until I
> change the row number, and then it displays the actual formula instead
> of the result. Any idea why it won't pull the result??
>
> Perplexed,
> Amy
>
>
> --
> webee33
> ------------------------------------------------------------------------
> webee33's Profile: http://www.excelforum.com/member.php...o&userid=28171
> View this thread: http://www.excelforum.com/showthread...hreadid=476983
>
>