How do I set default for a column so that first letters are caps?

[theo]

if a column is names, how do i set it so that the first letters are all caps?

 

[Roger Govier]

Hi Theo

No setting available to force what you want, unless you use an event in
VBA solution.
You can apply solution after the data is entered, by using a helper
column.
With original data in A1, in another column enter =PROPER(A1) and copy
down the column as far as required.
Then, copy the whole of the helper column and Paste Special>Values back
over the data entered in column A.
The helper column can then be deleted.

 

[David McRitchie]

Hi Theo,
For macro solutions to change in place when the macro is invoked
or for an event macro to change when a constant is entered in a column(s) see
http://www.mvps.org/dmcritchie/excel/proper.htm

Microsoft Word offers a formatting option, Excel does not.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Roger Govier" wrote