Formatting Cells

[Paul]

Is it possible to format cells to accept text and display that text in title
case? I am using Excel 2003.

 

[Dave Peterson]

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