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
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 SpecialValues back
over the data entered in column A. The helper column can then be deleted.

"theo" wrote in message
...
if a column is names, how do i set it so that the first letters are
all caps?