Feb 17 2017
05:44 PM
- last edited on
Jul 25 2018
09:26 AM
by
TechCommunityAP
Feb 17 2017
05:44 PM
- last edited on
Jul 25 2018
09:26 AM
by
TechCommunityAP
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.
Feb 17 2017 11:43 PM - edited Feb 17 2017 11:43 PM
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.