Forum Home
Press F1
 
Thread ID: 10496 2001-07-25 05:33:00 excel Guest (0) Press F1
Post ID Timestamp Content User
16089 2001-07-25 05:33:00 I am transcribing text lists to excel and wonder if there is a way to make the program default the first letter as upper case at the beginning of each cell? Guest (0)
16090 2001-07-25 22:29:00 There is no worksheet formatting available which will do this.
Using Visual Basic to capture the Worksheet_Change event, a macro can be supplied which will convert text entries to Lower, Upper or Proper case (every word starting with upper case letters). Having only the first letter of the first word in a sentence as upper case is not supported.
Guest (0)
1