Just Curious

[Mike Fogleman]

Excel is not the only app that does this and I have tried it on WinXP home
and pro with similar results. Maybe someone here has the answer. Turn on
Caps Lock and type uBR(space) using the Shift key to produce the lower case
u. As soon as you hit the Space Bar the text reverses case to Ubr. Any
takers on this? In my job there is a piece of equipment called a uBR and I
was trying to type an all caps header in Excel 2000 that said uBR PORTS.
After several attempts and a re-boot, I watched the text carefully after
each keystroke and that is what I found.

Mike F

 

[Norman Jones]

Hi Mike,

In my job there is a piece of equipment called a uBR

Maybe, a colleague has added this to as an autocorrect setting?

 

[Tom Ogilvy]

It is autocorrect, but it is the option to Capitalize the first letter of a
sentence. If I uncheck that in Tools=>Autocorrect, it doesn't do that. (at
least for me in xl97).

 

[Norman Jones]

Hi Tom,

Simpler still!

---
Regards,
Norman

It is autocorrect, but it is the option to Capitalize the first letter of
a
sentence. If I uncheck that in Tools=>Autocorrect, it doesn't do that.
(at
least for me in xl97).

 

[Charles Kee]

I had a similar problem with Outlook. I had a word with the first two letters
as caps.
I was tempted to turn off the capitalization autocorrect when I discovered
that I could
enter an list of exceptions. There may be something like that in Excel also
since it all
seems to work the same way.

 

[NickHK]

Mike,
In Office 2K it seems to be controlled by the "Correct Accidental use of
Caps Lock" setting.
Although the Exceptions route may be better.

NickHK

 

[Mike Fogleman]

Unchecking "Correct Accidental use of Caps Lock" setting does stop the
situation, but there seems to be no exception setting that will work.

 

[Mike Fogleman]

I got it. Replace ubr with uBR in the auto correct list.