ExcelBanter - Formula shows as text

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula shows as text (https://www.excelbanter.com/excel-discussion-misc-queries/262087-formula-shows-text.html)

EmilyE

Formula shows as text

I'm trying to write a formula into a cell and it will work in some, but in
other cells it makes the formula show in the cell as if I am just typing text.
Why is it doing this?! Please help!

FSt1

Formula shows as text

hi
make sure the cell isn't formated as text.

regards
FSt1

"EmilyE" wrote:

I'm trying to write a formula into a cell and it will work in some, but in
other cells it makes the formula show in the cell as if I am just typing text.
Why is it doing this?! Please help!

All times are GMT +1. The time now is 11:54 PM.