Hi,
is it possible to change data entered into any cell so that it appears as
CAPITAL LETTERS without actualy placing a formula (=UPPER(A2) into each cell.
I want this to apply to the whole worksheet.

thanks