Right click the tab at the bottom of the worksheet where you want this
functionality, select View Code from the pop up menu that appears, and then
copy/paste the following into the code window that appeared...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
Application.EnableEvents = True
End If
End Sub

Now, go back to your worksheet and type something into Column F in lower
case and watch it change to upper case.

--
Rick (MVP - Excel)


"Michael Koerner" wrote in message
...
Is there a way to set up say Col F to be all upper case when I type in it.
I
would just like to continue to enter data and not have to think that I am
entering a Canadian Postal Code and manually change the text to upper
case.
TIA

--

Regards
Michael Koerner