You have to place the formula in a different cell. For example if the text
"PrOper TeXt" was in A1 and you placed the formula =PROPER(A1) into B1, B1
would have the value "Proper Text"

--
Regards,
Dave


"Bruce" wrote:

I have followed previous postings but I am getting Circular reference errors
when I try to perform the fucntion on the cell I am trying to change.