Proper Formula is stuck and does not work

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

T
Fri Mar 14 12:06:27 CDT 2008

Try this...

Select cell E2
Goto the menu Edit>Replace
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" <Diggsy@discussions.microsoft.com> wrote in message
news:AB70510F-A125-41C3-B110-74AFBB5D0A9D@microsoft.com...
> 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

Diggsy
Fri Mar 14 12:46:00 CDT 2008

^Thank ou very much. Any Idea why that happens. I have had that proplem with
all kinds of formulas from time to time. Thanks again.

Chris

"T. Valko" wrote:

> Try this...
>
> Select cell E2
> Goto the menu Edit>Replace
> 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" <Diggsy@discussions.microsoft.com> wrote in message
> news:AB70510F-A125-41C3-B110-74AFBB5D0A9D@microsoft.com...
> > 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
>
>
>

T
Fri Mar 14 13:12:16 CDT 2008

Formatting the cell as TEXT causes that. As a general rule: Don't format any
cells unless you specifically need to for a specific reason!

If a cell is formatted as TEXT simply changing the format to GENERAL has no
effect *until* you edit the cell. The procedure I suggested is one way of
doing that.


--
Biff
Microsoft Excel MVP


"Diggsy" <Diggsy@discussions.microsoft.com> wrote in message
news:2ED565AE-C417-463E-804E-65050726AE86@microsoft.com...
> ^Thank ou very much. Any Idea why that happens. I have had that proplem
> with
> all kinds of formulas from time to time. Thanks again.
>
> Chris
>
> "T. Valko" wrote:
>
>> Try this...
>>
>> Select cell E2
>> Goto the menu Edit>Replace
>> 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" <Diggsy@discussions.microsoft.com> wrote in message
>> news:AB70510F-A125-41C3-B110-74AFBB5D0A9D@microsoft.com...
>> > 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
>>
>>
>>