problem: formula appears as text

  • Thread starter Thread starter couriced
  • Start date Start date
C

couriced

Hello...I'm stumped....

I am entering a simple formula: =RIGHT(A2,2) in a cell. The sheet has
data on it but not a whole lot going on. I have tried formatting the
cell itself, the column, and the entire sheet a number of
ways...however, the formula appears in the cell as =RIGHT(A2,2)...as if
were a text entry...it won't actually just turn into a formula and do
it's thing.

Thanks in advance for response....
 
couriced said:
Hello...I'm stumped....

I am entering a simple formula: =RIGHT(A2,2) in a cell. The sheet has
data on it but not a whole lot going on. I have tried formatting the
cell itself, the column, and the entire sheet a number of
ways...however, the formula appears in the cell as =RIGHT(A2,2)...as if
were a text entry...it won't actually just turn into a formula and do
it's thing.

Thanks in advance for response....
Click to expand...
Try control key ~ this toggles the view for formulas

gls858
 
I'm not sure what is going on as well. Generally, if a cell is
formatted as TEXT, you will experience this phenomenon. However, if
you are sure the cell with the formula is formatted as GENERAL and
still see this, I would try using the "Insert Function" method to see
if that takes.

On the main menu click Insert>Function and choose Text in the Category
drop down. Scroll down and select Right in the select box and click
OK.

enter your parameters as desired and click OK to insert this function
in the selected cell.

Does this work for you?
 
gls858 said:
Try control key ~ this toggles the view for formulas

gls858
Click to expand...

Oooooh, I had forgotten about that 'hot-key' combo. Good one! Thank
for the follow up!

Cheer
 
Thank you for the replies.

I have a few days off from work...when I return I will try that on the
user's sheet to see what happens.

The only way I could get it to work in the meantime, was to put the
formula on a whole new sheet...and then copy and paste the cell over to
the "wierd" sheet. That worked fine.
 
Back
Top