Formatting won't do that.
You might want to investigate a VBA solution.
--
David Biddulph

"nflor009" wrote in message
...
A follow up question on this topic:

How do I format a cell so that whatever is entered has the first letter
capitalized, as in a proper name. I tried the =PROPER(cell) but a formula
doesn't work since you delete it when you type into that cell, so I need
formatting, not a formula.

"rodchar" wrote:

hey all,
is there an easy way to capitalize just the first letter in a column and
leave the rest as is?

for example,
pubID -- PubID

thanks,
rodchar