Forum Discussion

Ken Shaw's avatar
Ken Shaw
Copper Contributor
Feb 18, 2017

Change Case

I have Excel 2016 on Windows 10. The Change Case formula doesn't seem to work. In cell D3 I type =PROPER(C3), and cell D3 treats that like a text entry rather than importing data from C3. It's probably me, but I can't see what I'm doing incorrectly.

Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Feb 18, 2017

    Hello Ken

     

    Either you are in view-formula-mode or the cell is text-formatted.

     

    Solution 1

    CTRL-SHIFT-´

     

    Solution 2

    Change the number format to "General". Then press F2 and ENTER.

     

Resources