| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Cells
Is it possible to format cells to accept text and display that text in title
case? I am using Excel 2003. |
|
#2
|
|||
|
|||
|
Not through formatting alone.
You could use a helper cell: =upper(a1) Or you could use an event macro like the one at Chip Pearson's site: http://www.cpearson.com/excel/case.htm look for: Changing Case On Data Entry Paul wrote: Is it possible to format cells to accept text and display that text in title case? I am using Excel 2003. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting.. how do I copy cells? | Excel Discussion (Misc queries) | |||
| conditional formatting adjacent cells | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
