formulas in excel

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
 
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)
 
Back
Top