On 5/6/2010 8:49 AM, Prashant wrote:
Hi All,

Need your help!!!

I need a setting/formula/Coding in such a way that whatever text I type in
sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.

I checked settings but did not find anything helpful.

Thanks in advance for your assistance!!!

Prashant.

Why not just hit Caps Lock key before you enter the information?
Then hit it again when you're done.

Bill