forcing caps lock
 

I have to setup a spreadsheet but i want to have all the data in the
same format.

Once they complete the data entry sheet the data is displayed on
another spreadsheet. I would like to make everything on this sheet in
capitals letters.

whether it is typed in caps or not.

Can it be done in either the entry sheet that it makes it caps or in
the formula transfering the data

thanks

ps - some cells are text and numbers if that makes a difference.


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=546928

forcing caps lock
 

Worked This Out

=upper()


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=546928