Excel Formulas not working


macrumors newbie
Original poster
May 15, 2011
Hi, I am using Mac Excel and when I enter a formula, it doesn't calculate, it just shows the formals as written. The formula I am using is =f1&f2. This formula works if I create a new workbook, but not in the one I have open. I have checked the preferences/Calculation and the radio button to automatically calculate is selected. Any suggestions on how to make this work much appreciated.


macrumors newbie
Dec 30, 2013
Excel formulas not working, they are copied as text

I tried all suggestions found here and elsewhere to no avail. Then I did this: I copied my table filled with data that needs calculations, open a new excel file, pasted the table, and in the bottom right corner of the new pasted table there is in icon that displays two options after you click it:

- Keep source formatting (this is selected by default)
-Match destination formatting (and I selected this option)

Hope it helps.


macrumors member
Feb 15, 2010
Not sure what you're trying to do with the two cells, so the following may just be ignorant rambling.

"&" concatenates the contents/results of two cells.

If f1 is "Hello" and f2 is " there", the result of =f1&f2 will be "Hello there".

If f1 is =7+1 & f2 is =8+2, then the result of =f1&f2 will be 810.

If that's not what you were expecting, tell us what you wanted to do. :apple:

Similar threads

Register on MacRumors! This sidebar will go away, and you'll see fewer ads.