Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Odd Quirk in Excel
Old 02-10-2009, 02:37 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
haha's Avatar
 
Join Date: Apr 2003
Location: Hooverville
Posts: 22,386
Odd Quirk in Excel

I am trying to make a simple valuation matrix for Loews Corp. When I list CNA in a cell, Excel transforms it to "CAN". No matter what formatting I have tried, it still happens. I could just ignore it, but I would prefer to fix it.

Any suggestions?

Ha
__________________

__________________
"As a general rule, the more dangerous or inappropriate a conversation, the more interesting it is."-Scott Adams
haha is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 02-10-2009, 02:42 PM   #2
Moderator
ziggy29's Avatar
 
Join Date: Oct 2005
Location: Texas
Posts: 15,613
How about entering this in the cell:

=CONCATENATE ("C", "N", "A")

Then optionally you can highlight that cell, and select "Copy" and then "Paste Special" -> "Values". That would remove the formula and just leave "CNA" as the contents of the cell.
__________________

__________________
"Hey, for every ten dollars, that's another hour that I have to be in the work place. That's an hour of my life. And my life is a very finite thing. I have only 'x' number of hours left before I'm dead. So how do I want to use these hours of my life? Do I want to use them just spending it on more crap and more stuff, or do I want to start getting a handle on it and using my life more intelligently?" -- Joe Dominguez (1938 - 1997)

RIP to Reemy, my avatar dog (2003 - 9/16/2017)
ziggy29 is online now   Reply With Quote
Old 02-10-2009, 02:44 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
haha's Avatar
 
Join Date: Apr 2003
Location: Hooverville
Posts: 22,386
Quote:
Originally Posted by ziggy29 View Post
How about entering this in the cell:

=CONCATENATE ("C", "N", "A")

Then optionally you can highlight that cell, and select "Copy" and then "Paste Special" -> "Values". That would remove the formula and just leave "CNA" as the contents of the cell.
Works! Thanks!

Ha
__________________
"As a general rule, the more dangerous or inappropriate a conversation, the more interesting it is."-Scott Adams
haha is offline   Reply With Quote
Old 02-10-2009, 02:45 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Nov 2007
Posts: 7,531
Don't type "HSA" either or you would get "HAS".

You can modify a setting to turn off auto-correct. From excel 2003 help:

Change spelling options for automatic corrections

  1. On the Tools menu, click AutoCorrect Options.
  2. On the AutoCorrect tab, do any of the following:
    • To add a new AutoCorrect entry, type the text that you want in the Replace and With boxes, and then click Add.
    • To edit an AutoCorrect entry, click it in the list, type the text that you want in the With box, and then click Replace.
    • To delete an AutoCorrect entry, click it in the list, and then click Delete.
__________________
FUEGO is offline   Reply With Quote
Old 02-10-2009, 02:59 PM   #5
Thinks s/he gets paid by the post
Free To Canoe's Avatar
 
Join Date: May 2008
Location: Cooksburg,PA
Posts: 1,738
Tools- Autocorrect, Uncheck the replace text as you type box. It worked for me.

Free
__________________
Free To Canoe is online now   Reply With Quote
Old 02-10-2009, 03:00 PM   #6
Thinks s/he gets paid by the post
Rustic23's Avatar
 
Join Date: Dec 2005
Location: Lake Livingston, Tx
Posts: 3,624
In Excel 2007 click on the Office button. Top right
At the bottom of the drop down menu you will see 'Excel Options' click
near the top there is a 'Autocorrect options' button click
There is a list of words that auto correct, Find cna and delete it.
__________________
Rustic23 is online now   Reply With Quote
Old 02-10-2009, 03:01 PM   #7
Moderator Emeritus
Khan's Avatar
 
Join Date: Aug 2006
Location: Pine Island, Florida
Posts: 6,868
Send a message via AIM to Khan
Quote:
Originally Posted by FUEGO View Post
Don't type "HSA" either or you would get "HAS".

You can modify a setting to turn off auto-correct. From excel 2003 help:

Change spelling options for automatic corrections

  1. On the Tools menu, click AutoCorrect Options.
  2. On the AutoCorrect tab, do any of the following:
    • To add a new AutoCorrect entry, type the text that you want in the Replace and With boxes, and then click Add.
    • To edit an AutoCorrect entry, click it in the list, type the text that you want in the With box, and then click Replace.
    • To delete an AutoCorrect entry, click it in the list, and then click Delete.
Been there, done that. Took me a bit to figure out.
__________________
"Knowin' no one nowhere's gonna miss us when we're gone..."
Khan is offline   Reply With Quote
Old 02-10-2009, 03:20 PM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Yes, turn off every "helpful" feature in Office that you can find. They get in your way and will confound you unless you are doing exactly what the authors anticipated you would be doing. And they do not anticipate you wanting to enter CNA instead of Can. Nope, you would *never* want to do that.

Also, look to see if there are any "auto complete" or "auto sequence" functions enabled. I've seen these take a phone number and change it from 555-1234 to 555-1235 when copied and pasted. Try figuring out why your pasted info is different from the copied info at 2AM on a deadline sometime....

At work, they would want to "re-image" my drive whenever there was a problem. It took me days each time to find all these and get them reset the way I wanted. I like being my own IT guy.

-ERD50
__________________

__________________
ERD50 is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd car names REWahoo Other topics 12 08-29-2008 03:21 PM
It's not a quirk, it did exactly what I told it to do, but... Nords Forum Admin 3 12-03-2007 01:52 PM
Sinus surgery - is this odd? gindie Health and Early Retirement 8 07-18-2007 03:48 PM

 

 
All times are GMT -6. The time now is 04:56 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.