Several ways:
http://www.officearticles.com/excel/...ft_exce l.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Trevor Coultart"
<Trevor.Coultart.1rqt2g_1120644331.6361@excelfor um-nospam.com wrote in
message news:Trevor.Coultart.1rqt2g_1120644331.6361@excelf orum-nospam.com...

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