I'm wanting to ensure that text entered by the user displays in upper case but I can't figure out how to do this. For example, if text is entered into cell A1, how can that text be changed to upper case?

I know that using the function UPPER() in some other cell will display the text in that cell in upper case but the text in A1 remains unchanged.