read my message

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron Carr" wrote in message
...
Turns out it is a circular reference since I am reffing to the same cell
the
formula is in. I assume that is why the entire formula is showing.
Show formulas applies to the whole spreadsheet and other formulas are not
showing.
I still would like to know how to auto-capitalize this field!
Ron

"Mike H" wrote:

Hi,

2 possibilites.

1. Most likely. The cell is formatted as text. Reformat as general, tap
F2
and Enter
2. You are set to display formulas instead of results. I know how to
change
this in excel 2003 so you'll have to look in Help for 2007.

Mile

"Ron Carr" wrote:

Nope. tried it both ways, with and without the +.
Ron

"Mike H" wrote:

Hi,

the correct syntax is

=Upper(f5)

Mike

"Ron Carr" wrote:

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