Excel Formulas not working

[dvbeatty]

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.

 

[mjo404]

make sure the cell is formatted correctly... i.e. not formatted as "text"

 

[dvbeatty]

Thanks

 

[alpop]

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.

 

[rc135tx]

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.