topic [Q] Question on using Excel in Operating System - Microsoft

[Q] Question on using Excel

Tony, Lim — Thu, 23 Mar 2006 21:40:33 GMT

All ..

I have two question on using Excel

Firstly, I am using office 2003 and using excel template for managing user account.

there are a colume using input user's e-mail address on that template excel file.

As you know, e-mail address in excel is changed to hypertext automatically.

How can I prevent changing hypertext in Excel ??

Secondly, that template is using by End-user, and they would submit that one to request.

So, I would like to restric just can input lowercase in some column.

How can I do this ?

I need your help, all..

thanks in advance

Re: [Q] Question on using Excel

Allan Bowman — Thu, 23 Mar 2006 22:42:46 GMT

To disable the email hyperlink, you have 2 choices. You can either precede the entry with a single quote when entering it - this will treat your entry as plain text, or, after you enter the info, you can right click on the cell and select "remove hyperlink". I am not sure how to force this behavior if your user is entering the data.

To force lower case, you can use the LOWER function on the text. This may require that the user enter the text in a scratch area and then the "real" cell copies it with the LOWER function.

Allan in Atlanta

Re: [Q] Question on using Excel

Jorge Pinto Leite — Sun, 26 Mar 2006 09:24:02 GMT

Hi Tony

You can avoid e-mail addresses from beeing changed to hypertext selecting Tools/Options/Speeling/Automatic changes options and in the label Format while writing uncheck the box Internet and network places with hyperlink (sorry but my Excel is in portuguese, so I expect to have translate it well, or at least, understandable...)

Good luck
Jorge

PS: Please note that this only applies to new cells, the already formated as hypertext will keep same behaviour.