I have columns that the user enters x or nothing. Purely for aesthetics I
would like it to auto-capitalize, so I entered the function "=UPPER(+F5)"
where F5 is the current cell. What shows is excatly what I just entered: ie.,
the function! So there are two questions, why do I have the =UPPER etc
displaying in the cell and is it the correct use of the function to uppercase
the contect in the cell.
Excel 2007.
Many thanks!
Ron