Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do Excel functions return the text and not run?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do Excel functions return the text and not run?
Is the cell formatted as text, if it is change it to general, then select
the cell, press F2 and enter -- Regards, Peo Sjoblom "Bill" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MIN and IF functions return no value if there is no date | Excel Worksheet Functions | |||
Most functions do not work and return #Name? | Excel Worksheet Functions | |||
Help with Excel array functions - select, add & return result | Excel Worksheet Functions | |||
How to return value from functions in other sheets? | Excel Worksheet Functions | |||
Create a function to return text if two logical functions are true | Excel Worksheet Functions |