Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Archive: Business Applications
Tag Cloud
access acer asus bios bsod computer crash driver drivers error ethernet excel freeze gaming gpu hard drive hardware hdmi internet laptop mac malware memory monitor motherboard music network printer problem ram registry router server slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
Solved: Turning off abbreviation auto complete in Excel ?

Reply  
Thread Tools
Joham's Avatar
Junior Member with 4 posts.
 
Join Date: Oct 2008
Experience: Advanced
13-Oct-2008, 03:41 AM #1
Solved: Turning off abbreviation auto complete in Excel ?
Hi

I use Excel 2003.
I work as an engineer and write scientific abbreviations for units a lot
Some of these gets auto competed into norwegian expressions (my language), which i do not want them to do.
For example, when i write "mm" (milimetres) and hit enter Excel turns the cell into "med mer", which is the expression you get from the norwegian abbreviation "mm".
This is quite annoying as you can propably understand

How do i turn this off ?

Thank you
Joham's Avatar
Junior Member with 4 posts.
 
Join Date: Oct 2008
Experience: Advanced
13-Oct-2008, 04:49 AM #2
Thanks, but thats not the option im looking for
Joham's Avatar
Junior Member with 4 posts.
 
Join Date: Oct 2008
Experience: Advanced
13-Oct-2008, 05:16 AM #3
Great, worked like a charm

Thanks
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
13-Oct-2008, 10:25 AM #4
First, welcome to the Forum!
??? No replies to you are visible; could you please post what the solution was for other users?
Also, if you have figured it out, please use the button at the top to mark this thread as Solved.
jonvan's Avatar
Member with 66 posts.
 
Join Date: Oct 2008
Experience: Advanced
13-Oct-2008, 10:36 AM #5
Not sure how he found the answer without any replies to his messages?

But....

In Excel go to Tools->AutoCorrect Options

In the dialog box there are several different settings regarding auto complete. To disable abbreviations being replaced uncheck "Replace text as you type".

That should do the trick.
Joham's Avatar
Junior Member with 4 posts.
 
Join Date: Oct 2008
Experience: Advanced
22-Oct-2008, 03:37 AM #6
Hi

I stumbled upon this page again by accident, misclicked a bookmark
I didnt know i had to mark a thread as solved, and have done so now
I still cant see the help-posts though

The person that helped me (Super_tech_guy) has the line "Account disabled with 0 posts" under his nickname
Maybe the user was removed and all his posts deleted ?
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 05:20 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.