Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UPPER function | Excel Worksheet Functions | |||
Upper case and Date problem | Excel Programming | |||
Upper & Lower case problem in VBA | Excel Discussion (Misc queries) | |||
Help With The Upper Function | Excel Worksheet Functions | |||
Upper/Lower case problem | Excel Programming |