excel 2002 formula not working

  • Thread starter Thread starter cindyc
  • Start date Start date
C

cindyc

have an end user who is using excel 2002 and puts = 1+1
into a cell and nothing happens. she copied and pasted the
data from another worksheet because the same thing was
happening. Any suggestions????
 
Does she have the cell formatted as text?
format|cells|number tab|General
(and reenter the formula)

Is she showing formulas:
tools|options|view tab|formulas (checked)

Is she prefixing the formula with an extra space: " =1+1"

If none of these helps, what do you mean by nothing happens?

What shows up in the cell?
 
Cindy

"Nothing happens" means what?

No answer(2) returned? Just a blank cell?

The formula shows as =1+1 ?

Perhaps the user has formulas set to show.

Tools>Options>View. Uncheck Window Options "formulas".

Alternative.....the cell was pre-formatted as Text.

Format to General then hit F2 then <ENTER> key.

Gord Dibben Excel MVP
 
Back
Top