Proper Function Doesn't Work

[wayneshirley]

Hi there,

I have a spreadsheet that is downloaded from a network. The names in column C are in upper case and I want to use the "Proper" function to convert to upper and lower case.

Each time I use this function (in column D) it produces the words "=PROPER(C)". Column D is formatted as text. Does anyone know why this occurs?

Thank you.

 

[RoryA]

format column D as general and then enter the formula again otherwise the formula itself is treated as literal text.