I'm new at this, but does this help In cell B1 put =PROPPER(A1). Assuming A1
is the text you wish to capitalise.

--
Browny


"Paul Brothers" wrote:

Hi All,

I am trying to get excell to format each line with a capital letter ,
I use to be able to set this in older versions of offic ethough am having
trouble with it now.

I am trying to set it so that the format is the same default whenever a new
document is created and the same for the font.

Any help greatly appreciated.

Paul