Hey

I've been using the proper function this morning and its not working for
some reason.

Cell B3 contains the word: MISS
I want cell C3 to contain the word: Miss
So, in cell C3 I typed: =proper(B3)

But it didn't work. Cell C3 has =proper(B3) in it. Not Miss.

Any ideas?

Perhaps,

Tools|Options|View and un-check formulas.

Mike

"Adam" wrote:

Hey

I've been using the proper function this morning and its not working for
some reason.

Cell B3 contains the word: MISS
I want cell C3 to contain the word: Miss
So, in cell C3 I typed: =proper(B3)

But it didn't work. Cell C3 has =proper(B3) in it. Not Miss.

Any ideas?

C3 was probably formatted as text, unknown to you. Just format C3 as either
general or number, then click inside the formula bar, press ENTER to
re-confirm.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Adam" wrote:
Hey

I've been using the proper function this morning and its not working for
some reason.

Cell B3 contains the word: MISS
I want cell C3 to contain the word: Miss
So, in cell C3 I typed: =proper(B3)

But it didn't work. Cell C3 has =proper(B3) in it. Not Miss.

Any ideas?