I am trying to have what ever is entered in a group of cells format the
same(1st letter upper case, rest lower) I have done =proper(a1) and pasted to
the proper cell. The problem is once I type something else in the cell it
reverts to normal.

Is there a way to make all future entries in the range of cells show as
proper format?
--
Thanks Everyone
Mike