you can convert existing data to uppercase using =upper()
to do it on the fly you'd need to apply a macro as above
--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile:
http://www.excelforum.com/member.php...o&userid=36330
View this thread:
http://www.excelforum.com/showthread...hreadid=563380