View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MEAD5432 MEAD5432 is offline
external usenet poster
 
Posts: 28
Default Excel only shows formula and not result

I am working in Excel 2000 and I have an entire column that I have typed in a
function and it shows the function rather than the result.

For instance:
In the formula bar for cell A1, I typed =5+3. When I hit enter, the cell
has =5+3 rather than 8.

This is not an issue with my views because it is only happening in the one
column. I can go a column on another worksheet or even all the way to the
right of my data and the formula works just fine.

Thoughts anyone?