Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
@-sign in Excel 2000
Posted by Amar Khalifeh on October 18, 2000 11:39 AM
Excel 2000 automatically assumes that @-sign should only be a part of an email address. If it's entered anywhere in a spreadsheet, Excel converts the contents of the cell where the @-sign is entered into an email address. Is there any way to change the default setting to where it does not do that anymore? Doing this one cell at a time is not what I expect to do. MS Word allows such setting change. I can't find it in Excel.
Re: @-sign in Excel 2000
Posted by Christopher Mains on October 19, 2000 1:02 PM
I just tried it out if you put a space between anything around this @ sign you wont have that blue underline that functions as a mailto. other then that I can not find a switch to turn that option on or off. sorry
Christopher
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.