excel 2002 formula not working

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????
 
D

Dave Peterson

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A couple questions BEFORE using Office 365 0
Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Excel does not accept text format! 0
Word 2016 opening sooo slow 0
Merging from an Excel file with graphics 1

Top