Use of =PROPER in Excel workbook

[Lisacpa]

I just figured out that this existed (=PROPER to change fields that are capitalized, so that the first letter of each word is capitalized), yay! But am having the dumbest issue with it: my workbook displays the formula, not the result.

 

[MARK858]

If it is happening with all formulas then Formula tab then click Show Formulas.
Also check if the cell is formatted as text rather than General.

 

[Lisacpa]

Odd. I did check that the Show Formulas was deselected. I just retyped the formula, and suddenly, it worked. The same thing happened when I tried to use this function again in a different column. Thanks very much!

 

[MARK858]

That sounds like you had a space in front the = sign to or your calculation is set to manual.