Try this...

Select cell E2
Goto the menu EditReplace
Find what: =
Replace with: =

Yes, you want to replace the = sign with an = sign!

Click the *replace* button (not the replace all button)
Close

Now, select E2 and copy down as needed.

--
Biff
Microsoft Excel MVP


"Diggsy" wrote in message
...
Hello,
I was wondering why my text formula of proper is not working. I have
placed
the formula =proper(f2) in column e2 All I get is the formula =proper(f2)
and
nothing else. It looks like it is stuck. When I try to copy down the whole
column e has the same formula. I have tried formatting column F to text
and
General and the formula does not do anything. I have had this problem in
the
past with other formulas.

Chris