VBA to Format a Table Column in Excel

[Sgt Rock]

This should be most simplistic and I've tried several attempts at the code.
My last endeavor:

This is part of a worksheet change event if that helps, and the information is in an Excel Table.

If Not Intersect(Target, Range("DataEntry[Threshold]")) Is Nothing Then
        
            With Target
                Application.EnableEvents = False
                .NumberFormat = "#,###"
                Application.EnableEvents = True
            End With
            
    End If

The value in the column "Threshold" is calculated from a formula. I'm sure it is something ultra simple. Any assistance would be most appreciated.

Best weekend wishes, Sgt. Rock (Mort)