To convert existing entries to Proper case you can try

=PROPER(A1)

If this post helps click Yes
---------------
Jacob Skaria


"alba146" wrote:

Despite being selected in the Excel Options - autocorrect when I type a word
in my spreadsheet it wont start with a capital letter - any suggestions ??