Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.

Robert11 wrote:
Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.


Click on the orb (office button), at the bottom of the dialog box click
options, then proofing, check ignore uppercase.

gls858

My guesses would be either AutoCorrect on certain words or some event code.

Do you know if you have any VBA code in the workbook?


Gord Dibben MS Excel MVP

On Mon, 9 Mar 2009 11:41:39 -0400, "Robert11" wrote:

Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.

Is there other text in the column that shows the same occurrence of the
word with a capital as the first letter?

Robert11;261617 Wrote:
Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as
before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become
reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73006

Good point Simon


Gord

On Mon, 9 Mar 2009 16:55:56 +0000, Simon Lloyd
wrote:


Is there other text in the column that shows the same occurrence of the
word with a capital as the first letter?

Robert11;261617 Wrote:
Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as
before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become
reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.

Hi,

All works now.
Thanks again, all.
Nice of you folks.

Bob
--------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Good point Simon


Gord

On Mon, 9 Mar 2009 16:55:56 +0000, Simon Lloyd
wrote:


Is there other text in the column that shows the same occurrence of the
word with a capital as the first letter?

Robert11;261617 Wrote:
Hello,

Should have stayed with Excel '97
But, have upgraded to Excel 2007.

Here's a weird one:

I have a word in a cell.
Nothing unusual; starts with a capital, then all small letters.

Want to make it all caps.

But, it won't let me !

I type in the word in caps and press Enter, and, and it reappears as
before.
If I delete the word first, and then type it in anew, same result.

Other cells, no problem
So, I guess this cell, and a few others, has somehow become
reformattet, or
locked, or...?

What's going on, please ?

Thanks,
B.