DPChallenge: A Digital Photography Contest You are not logged in. (log in or register
 

DPChallenge Forums >> General Discussion >> stupid Excel question, please help!
Pages:  
Showing posts 1 - 7 of 7, (reverse)
AuthorThread
02/16/2006 10:33:58 PM · #1
I need to type "MYU" into a cell but it keeps changing to "MY" for me.
I have tried typing 'MYU but it wont work. This is dumb, but please help!

Thanks
02/16/2006 10:41:09 PM · #2
Go to tools, then auto correct options. Find the bit where it says change myu to my and delete it.

edited to add: I had no idea it did that. You made me look for the solution and I learnt something new, too :-)



Message edited by author 2006-02-16 22:43:15.
02/16/2006 10:42:24 PM · #3
Originally posted by Beetle:

go to tools, then auto correct options. find the bit where it says change myu to my and delete it


THANKS! works like a charm.
Now you all know how illiterate I am with these things, hehe
02/17/2006 08:24:26 AM · #4
The other thing you can do if you need to type something into a cell which will ignore any Auto-corrections is, use the apostrophy (') before typing any text.
It will mean that you never need to go looking for any auto-correction setting to 'turn off'
This should then allow you to make as many spelling "mistakes" as you please...
Shane

Message edited by author 2006-02-17 08:26:06.
02/17/2006 08:28:14 AM · #5
Originally posted by smca74:

The other thing you can do if you need to type something into a cell which will ignore any Auto-corrections is, use the apostrophy (') before typing any text.
It will mean that you never need to go looking for any auto-correction setting to 'turn off'
This should then allow you to make as many spelling "mistakes" as you please...
Shane


This didn't work for me....hummm
02/17/2006 08:35:52 AM · #6
You can also watch for a little square symbol that Excel puts on the screen (beside the cell you're modifying) when it auto-corrects - right click that symbol and choose no auto-correction.

This is for newer versions of Excel.
02/17/2006 08:36:48 AM · #7
If you don't want to disable the auto-correct, you can use "undo" immediately after the automatic change has been made. So, for example, you type MYU and it switches to MY after you tab to the next cell--press CTRL + z so the change will be undone and tab to the next cell--no change should occur on the second time. This also works in MSWord where I use it to remove hyperlinks that are automatically added--I don't want to turn the feature off, so I just undo and continue on.
Pages:  
Current Server Time: 03/12/2025 06:34:35 PM

Please log in or register to post to the forums.


Home - Challenges - Community - League - Photos - Cameras - Lenses - Learn - Help - Terms of Use - Privacy - Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 03/12/2025 06:34:35 PM EDT.