Hi

In my Excel workbook I have multiple formual's which I want to copy into other cells. When using ctrl -C and ctrl-V it only copies the outcome (value) of the cell I am copying from but no formula is being copied. For isntance Cell A1 has the following formula = 2*7 so the actual value of the cell is 14. When I copy paste this cell into A2 then A2 only states the number 14 but no formula is being copied. I just installed a new version of Excel (Excel 2010) and somehow the settings appear to be "wrong"but I have no clue where to look.