I need to format a column so that all cell force any text entry to
uppercase. I've looked into the UPPER() function, but that is something that
would actually take the value from some otther location and display it in
uppercase where the fuction is located, which will not work.

What I'm looking for is something similar to Format-Cells-Numbers, which
allows you to define a format for numbers, so that however a number is
entered in the cell it automatically displays it in the desired format. So
I'd like to be able to have the data entry be in upper or lower case, but
the cell automatically displays it in uppercase. Can that be done?