Forum Discussion
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 probab...
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.