Use of =PROPER in Excel workbook

Lisacpa

New Member
Joined
Feb 5, 2016
Messages
4
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. :confused:
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,327
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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.
 
Last edited:

Lisacpa

New Member
Joined
Feb 5, 2016
Messages
4
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,327
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
That sounds like you had a space in front the = sign to or your calculation is set to manual.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top