Help? Functions Won't Calculate

  • Thread starter Thread starter Arsenio Oloroso
  • Start date Start date
A

Arsenio Oloroso

I've inserted a column in a spreadsheet I downloaded and typed in a
formula (vlookup). But when I hit enter, the formula doesn't
calculate--even though it's typed correctly, including the equals sign
at the beginning.

In fact, when I copy the formula into other cells in the column, Excel
just duplicates the formula as a text string.

To make sure I wasn't doing anything wrong, I typed in a simple
=SUM(x,y) formula into the column and copied it into other cells in the
column. That didn't work either, nor did =2+2.

Much obliged for any suggestions.
 
Make sure the formula cells are not formatted as text (format as general)
then to trigger a calculation do edit>replace and replace = with = (replace
equal sign with equal sign)
 
Peo said:
Make sure the formula cells are not formatted as text (format as
general) then to trigger a calculation do edit>replace and replace =
with = (replace equal sign with equal sign)
Click to expand...
Thank you.

That was the solution!
 
Back
Top