Why do Excel functions return the text and not run?

B

Bill

I am using Excel 2007. When I try a function in cell b2, like =upper(a2), it
enters the function text ("=upper(a2)" and it does not return the uppercase
contents of cell a2. Cell a2 contains lower case text. Is there a setting or
protection that needs to be disabled?
 
P

Peo Sjoblom

Is the cell formatted as text, if it is change it to general, then select
the cell, press F2 and enter


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Return a value if a range of cells contain text 2
Excel functions do not execute 4
Word macro that can call cells out of Excel for a find and replace 0
search function using wildcard 3
Combining cells with text 2
Help needed for Excel formula using if, iserr, match and vlookup! 1
Need formula to return next Monday's date 4

Top