formatting problem with functions

R

Robin M.

I have attempted to use the PROPER function in an adjacent column to my data.
I entered =proper(e1) and the cell only display the function not the result.
Help!
 
B

bj

check to see if the cell is formated as text
or
check <tools><options><view> and see if formulas is checked
or
select the equals sign and replace it with another equals sign (sometimes
works)
 
R

Robin M.

I'd tried all that. None of it works. Let me know if you have any more
ideas. Thanks.
 
G

Gord Dibben

Robin

Select the range and format to General.

With reange selected, Edit>Replace

what: =
with: =

Replace all.


Gord Dibben Excel MVP
 
R

Robin M.

That worked! What an odd bug. Thanks Gord.

Gord Dibben said:
Robin

Select the range and format to General.

With reange selected, Edit>Replace

what: =
with: =

Replace all.


Gord Dibben Excel MVP
Click to expand...
 
Top