Hi all,

Does anyone know of a way I can force cell contents to appear in upper
case? I'm tidying up a worksheet that is completed by many users and
one of the columns is for a reference code which has three letters and
six numbers (ABC123456). Some users leave it in lower case, and the
resulting sheet looks a mess.

Can I get Excel to always display this column in upper case regardless
of what the user inputs?

Trevor


--
Trevor Coultart
------------------------------------------------------------------------
Trevor Coultart's Profile: http://www.excelforum.com/member.php...o&userid=24945
View this thread: http://www.excelforum.com/showthread...hreadid=384807