Software

Ask something
Discussion Locked

Excel 2000

0 helpful
7 replies

by nordiae

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a database setup in Excel 2000 which consists of email addresses. On many occassions, email addresses that I type in a spreadsheet are correct to the naked eyes but once clicked on reads a totally different address. Also, if working with email addresses it seems that somehow the mouse or cursor automatically (invisibly) copies email addresses to other blank or even filled fields. Example, if you put the cursor over a field it reads an email address. I am a user and no technical rep is able to figure what the problem is

7 replies

by dklippert

When you find a bad address, select the cell and the click on the Hyperlink Icon on the Toolbar (The World with a Link). This will tell you what the hyperlink is and the displayed text

by nordiae

I did this before. The "text to display" is correct but the "Email Address" is different. Just want to know why and how to correct this.

by leo-sun

It may help if you put a single quote ' in front of the e-mail address. My understanding is that the single quote ' will make the address a regular text field to Excel.

This discussion is closed to new replies.