blank cell returned
 

I am trying to use the function =countblanks()
When I put the function in the cell with a range of cells from a singular
row it brings back the function instead of the result.

I tried the ctl+v approach and still no value.

Suggestions?

Is your cell formatted as text, try this, format the cell as general, then
do editreplace and replace equal sign with equal sign (replace = with =)

--
Regards,

Peo Sjoblom


"kennette" wrote in message
...
I am trying to use the function =countblanks()
When I put the function in the cell with a range of cells from a singular
row it brings back the function instead of the result.

I tried the ctl+v approach and still no value.

Suggestions?

Thank you! It was the cell formatting.

"Peo Sjoblom" wrote:

Is your cell formatted as text, try this, format the cell as general, then
do editreplace and replace equal sign with equal sign (replace = with =)

--
Regards,

Peo Sjoblom


"kennette" wrote in message
...
I am trying to use the function =countblanks()
When I put the function in the cell with a range of cells from a singular
row it brings back the function instead of the result.

I tried the ctl+v approach and still no value.

Suggestions?