formatting problem with functions

[Guest]

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!

 

[Guest]

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)

 

[Guest]

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

 

[Gord Dibben]

Robin

Select the range and format to General.

With reange selected, Edit>Replace

what: =
with: =

Replace all.


Gord Dibben Excel MVP

 

[Guest]

That worked! What an odd bug. Thanks Gord.

Robin

Select the range and format to General.

With reange selected, Edit>Replace

what: =
with: =

Replace all.


Gord Dibben Excel MVP