LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Using "@" unrelated to email address

When using Excel (Office 2000) worksheets to track my stocks, I use the "@"
symbol to mean "at" (like 500 @ 56.30). Instead the cell auto-formats it as a
formula (=) and tries to make an email address out of it (with little blue
underlined letters) and then tries to put me online. No matter how I try to
format the cell it is ignored. After a struggle I can trick it but there
must be a way to remove this auto cell conversion from a formula to a regular
cell format. Please help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split email address into seperat columns mg_sv_r Excel Worksheet Functions 1 January 9th 06 11:56 AM
How to format a cell as email address Steve Freides Excel Discussion (Misc queries) 4 September 21st 05 08:38 PM
stop automatically making email address lily Excel Discussion (Misc queries) 1 March 23rd 05 04:53 AM
how do I make make my hyperlinks show the email address they are . Dustin Excel Discussion (Misc queries) 0 January 13th 05 01:39 AM
Remove Email address header Mark Excel Discussion (Misc queries) 2 December 3rd 04 10:27 PM


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"