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

UPPER would be the right solution

Only 2 p's in =PROPER(A1)

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

No Proper is what is used for A capital letter at the beginning of each
word. UPPER will capitalize the entire text.

Jarek Kujawa wrote:

UPPER would be the right solution