The simplest way is to select all cells and change to an ALL CAPS FONT like
Academy or Lithograph. Another method that may work for you is to copy/paste
the area into Word, change case to UPPER and copy/paste back to Excel. Excel
does not have this feature, so it can not do it for you.

Mike F
"Chris Hankin" wrote in message
...
Hello,

Could someone please advise on how I can make Excel 2003 automatically
change all text to upper-case in my spreadsheet named "Register".

Any help would be greatly appreciated.

Thanks,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***