blank cell returned

[kennette]

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?

 

[Peo Sjoblom]

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

 

[kennette]

Thank you! It was the cell formatting.

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