Hi John,

Yes, it is possible to pre-format a column of cells as "text" and set it to automatically convert any entered text to UPPER CASE. Here's how you can do it:

1. Select the column of cells that you want to format.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, click on the "Number" tab.
4. Select "Text" from the Category list.
5. Click on the "Custom" option in the Type list.
6. In the "Type" field, enter the following code:
   
   
   Formula:

   @ 

7. Click "OK" to close the dialog box.

Now, any text entered into the selected cells will automatically be converted to UPPER CASE. You can test this by typing in some text in lowercase and pressing Enter. The text will automatically be converted to uppercase.