G Guest Jun 29, 2005 #1 Is it possible to format cells to accept text and display that text in title case? I am using Excel 2003.
Is it possible to format cells to accept text and display that text in title case? I am using Excel 2003.
D Dave Peterson Jun 29, 2005 #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
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
