Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Cells
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 |
#2
|
|||
|
|||
Can't be done with formatting. You can do it with an event macro (VBA).
The archives http://groups.google.com/advanced_gr...ugroup=*excel* have lots of examples. For instance: http://groups.google.com/group/micro...amming/tree/br owse_frm/thread/939824c77c99da47/2ef3a9722e83a170 In article , "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 |
#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 |
Reply |
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) |