| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Hi,
Not in the same column where entries are made. However, you could have a helper column with the formula, B2=UPPER(A2), and fill-down the formula in column B. Regards, B. R. Ramachandran "Paul" wrote: Hi there Does anyone know whether and if so how to format a cell so that text will covert to CAPITAL even if the entry is done in lower case? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
| How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
| Formatting Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
