formulas in excel

[Tom]

I'm having trouble dislaying the results of my formulas. I've typed
the formulas in and that's what is displaying instead of the results.
I know I'm overlooking something but I just can't seem to figure it
out. Can someone please point me in the right direction. Thanks in
advance.

Tom

 

[Frank Kabel]

Hi Tom
your cell is porbably formated as 'Text'. Goto 'Format - cells' and
change the format to 'General'. After that reenter your formula

HTH
Frank

 

[David McRitchie]

other possibilities besides begin formatted as text.

you are in formula view
Tools, Options, View, (uncheck) formulas
keyboard shortcut: toggle with Ctrl+` (accent grave)

you pasted or typed in formatting codes so it's not a formula, or
included spaces at the front before the equal sign.

Some tests you can use can be found at and above
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Would also check that you have calculation turned on (set to automatic)