Change Case

[Ken Shaw]

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.

[#2]

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.

[#3]

Thanks!!!