ExcelBanter - cell displays function not value of function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell displays function not value of function (https://www.excelbanter.com/excel-worksheet-functions/118338-cell-displays-function-not-value-function.html)

Gina

cell displays function not value of function

this is irritating. I don't think i'm doing anything differently, but I am
obviously doing something wrong. Plus I thought I saw this in a thread
recently and can't seem it find it. so sorry for a repeat question!
--
Gina

Dave F

cell displays function not value of function

Your cell is probably formatted as text.

Dave
--
Brevity is the soul of wit.

"Gina" wrote:

this is irritating. I don't think i'm doing anything differently, but I am
obviously doing something wrong. Plus I thought I saw this in a thread
recently and can't seem it find it. so sorry for a repeat question!
--
Gina

Gina

cell displays function not value of function

Dave F you're my hero
--
Gina

"Dave F" wrote:

Your cell is probably formatted as text.

Dave
--
Brevity is the soul of wit.

"Gina" wrote:

this is irritating. I don't think i'm doing anything differently, but I am
obviously doing something wrong. Plus I thought I saw this in a thread
recently and can't seem it find it. so sorry for a repeat question!
--
Gina

All times are GMT +1. The time now is 05:37 AM.