WE'RE SURE THAT YOU'LL LOVE US!
Hey there! 
Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. 
Join 93112 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.
Try What the Tech -- It's free!
Best Answer Tomk , 31 May 2015 - 03:18 PM
Looks right to me. If you delete the equals sign (=) the formula would show in the cell as text - but of course there would be no equals sign showing. Other than that, the only way I know how to show the formula in the cell - complete with eq...
Go to the full post 
Silver Member
Posted 31 May 2015 - 01:59 PM
I have this formula in a cell = COUNTIF(May!$E:$E,"o") when I attempt to change the "o" to "a" the formula displays in the cell as an actual formula
=COUNTIF(May!$E:$E,"a") displays in the cell but does not work.
Hope I make sense.
Register to Remove
Beguilement Monitor
Posted 31 May 2015 - 03:18 PM Best Answer
Looks right to me.
If you delete the equals sign (=) the formula would show in the cell as text - but of course there would be no equals sign showing.
Other than that, the only way I know how to show the formula in the cell - complete with equals sign - is to hold control and accent key (`). Formula would then continue to show until you click in the cell and hit Ctrl ` again.
Silver Member
Posted 31 May 2015 - 03:25 PM
As it turned out it was the cell format, I changed to general and that allowed the change.
Beguilement Monitor
Posted 31 May 2015 - 03:35 PM
0 members, 0 guests, 0 anonymous users
Community Forum Software by IP.Board
Licensed to: What the Tech
