Formula shows as the result?

B

Bec

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

Ragdyer

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>.
 
T

TazGuy37

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.
 
M

mangesh_yadav

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

Mangesh
 
K

keithl816

Hi Mangesh,

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

An example needs to be posted
 
Top