Hi all,

I would like to ask:
How to automatically change the first letter of entry to upper case.
That is:
abc -- Abc
I know I can use a function "Proper", however, how can I change the entry once I press enter?
Do I need to write Macro or VBA?
I am very weak in writing Macro manually.

Please help, thanks all.

K.Parker

Hi
Rather than taking any credit for this have a look at this link and see if
it's of any help
http://www.cpearson.com/excel/case.htm
;-)

K.Parker wrote in message
...
Hi all,

I would like to ask:
How to automatically change the first letter of entry to upper case.
That is:
abc -- Abc
I know I can use a function "Proper", however, how can I change the entry
once I press enter?
Do I need to write Macro or VBA?
I am very weak in writing Macro manually.

Please help, thanks all.

K.Parker

Thanks a lot, I am trying on this.
"Loomah" ¦b¶l¥ó ¤¤¼¶¼g...
Hi
Rather than taking any credit for this have a look at this link and see if
it's of any help
http://www.cpearson.com/excel/case.htm
;-)

K.Parker wrote in message
...
Hi all,

I would like to ask:
How to automatically change the first letter of entry to upper case.
That is:
abc -- Abc
I know I can use a function "Proper", however, how can I change the entry
once I press enter?
Do I need to write Macro or VBA?
I am very weak in writing Macro manually.

Please help, thanks all.

K.Parker