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