EXCEL CALCULATIONS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to perform a simple calculation: =j56-k56
I cannot get any formulas to calculate, only show the actual formula itself
I have checked that these cells are formatted as numbers
This seems to happen on any cell I try in the worksheet
 
I take it you have values in cells J56 and K56? If you type in =j56-k56, it
should change to =J56-K56, and give a total. Else try the insert formula
icon, and type in your formula that way. If you still have no joy, your
cells may be formatted as text?
 
Steve

Is this just in one book or all? If it's just one, select an empty cell and
copy it. Highlight the remaining empty cells and select Edit>paste
special...>Values and add. Now try entering the formula

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Either you have Excel set to display formulas (Tools / Options / View /
Formulas), or your cells are formatted as text.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top