or use the format painter (standard toolbar). type something in upper case into a cell and with this cell selected, double click the format painter. click on the top left cell you want 'uppered', hold down the shift key and click on the bottom right cell to be uppered and press enter.
hth This message was edited by anno on 2002-09-17 20:34
ok, slightly more convoluted way to do this but it should work. before you do this though note that if you have any formulas they will be gone.
select a range of cells the same size as those you want to change to upper case. in the formula bar type =UPPER(your cell range) and press ctrl+shift+enter simultaneously. now copy the array, select the first cell of your old range and go to edit>paste special>values. this should make everything upper case and preserve formats.