[Q] Question on using Excel

[wolfhyun]

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

[John James]

Don't know of any in-built features satisfying your needs, but do these workarounds help at all?

1. If you format your cells as dates, when the email addresses are entered they aren't converted to hyperlinks

2. Another column could be used to convert your email address to lower case. e.g. =lower(C1) converts the contents of cell C1 to lower case.

If this is unsatisfactory you could write a macro which does the conversion to lower case and removes the hyperlinks.

[ie]

do u know how to put in formulas like dividing formulas

"wolfhyun" wrote:

> 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

[Dave Peterson]

#1. Tools|autocorrect options|autoformat as you type
Uncheck replace as you type box.

#2. If you don't want to use John's formula (=lower()), you could use an event
macro that changes case when the user hits enter.

See Chip Pearson's site for the code you'd need:
http://cpearson.com/excel/case.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

wolfhyun wrote:
>
> 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

--

Dave Peterson