No result!

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi , i have a query, sometimes the formula doesn't yield the result which it
should, even simple things like =d2-c2.

The result is "=D2-C2"

while if i try it in some other cell or say other worksheet , it works fine!

Any ideas?
 
Hi Jim,

Your cells were formatted as text before you entered the formula.
Format as General and re-enter the formula (F2, ENTER)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Jim, sounds like the cell is formatted as text
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
And if Niek's answer didn't help, try:

tools|options|view tab
make sure formulas isn't checked.

(and no leading space before that = sign.)
 
Back
Top