Excel quirk?

[Don Piper]

In Excel 2002, typing the letter "a" by default
capitalizes within the middle of the sentence. How do I
correct this without having it being effected if used at
the beginning of a sentence?

 

[Tushar Mehta]

You probably have an autocorrect entry. Check Tools | AutoCorrect
Options...

Also, I didn't know XL had the built-in capability of upcasing the
first letter of a sentence. ;-)

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[RagDyer]

Tushar,

What does
<Tools> <AutoCorrect> <CapitalizeFirstLetterOf Sentance>
do ?

It's there, but doesn't seem to do anything on my XL2k.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

You probably have an autocorrect entry. Check Tools | AutoCorrect
Options...

Also, I didn't know XL had the built-in capability of upcasing the
first letter of a sentence. ;-)

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

Oh, yeah. Now, I remember. XL apparently believes a sentence is
something that follows a period (dot), not necessarily text that starts
a cell entry (*). So, if you type "hello, there. this is me" XL will
upcase the t in this.

(*) I imagine one could argue either way about the propriety of
upcasing the first letter of text in a cell.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions