When I link a cell within a workbook the formula shows where to result
should. How do I fix this.

Most probably, the cell was formatted as Text before you entered the
formula.

Change the format to "Number" or "General", then re-enter the formula.

Keyboard shortcut is:
Select the cell, then,
<Ctrl <Shift <~,
Then <F2,
Then <Enter.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bec" wrote in message
...
When I link a cell within a workbook the formula shows where to result
should. How do I fix this.

Perhaps you're in formula view. Try (this works in 2000, not sure about
other versions) Control-` to see if you've inadvertently selected that mode.
--
Hope that helps!
TazGuy
XL2000 on Windows 2000

"Bec" wrote:

When I link a cell within a workbook the formula shows where to result
should. How do I fix this.

Check your formula


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=374106

The formula of the source cell, or the formula of the destination
cell...?

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374106

Hi Mangesh,

I believe it would be in the destination cell. But without an example
it would be hard to say.

An example needs to be posted.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=374106