Avoiding "proper" format in cells

M

Mike Echo

Is there a setting for cells that makes text appear as though it was
=proper()? If I type in AName (first two letters uppercase) in a
generally formatted cell my Excel2000 automatically makes it Aname when
I hit enter. Can I turn this annoyance off somehow?

TIA.
 
M

Mike Echo

Within Excel, Click Tools-->AutoCorrect Options and deselect the "Correct
TWo INitial CApitals" option.
Click to expand...

Well done! Silly me thought it would be in Tools > Options. Thanks Rob!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to format text 'exactly' as entered. 3
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Using Styles In An Outline 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How can I apply a function (PROPER) to multiple cells at once? 3
Conditional Formatting help please 0
Need a proper guru! My head hurts ;( 1
Text Formatting For Printout and Proper Case 5

Top