You can not change the input to become proper case but you can set another
cell to return the input in proper case. So if you input cell is A1 then in
B1 add the formula =Proper(A1).

Otherwise you can add a custom validation that would require the user to
enter the value in proper case but the users may not be too impressed when
the value they enter is not accepted and they need to retype it.
--
HTH...

Jim Thomlinson


"igbert" wrote:

Is there a way to confine a cell for Proper Case without invoking a macro?

i.e.

If I type "enter account number" in cell A1, cell A1 (not any other cell)
should automatically change to "Enter Account Number" without running a macro.

Thanks.

Igbert