Would this go into the Cell Validating Method, or CellEndEdit.

I just don't understand why it doesn't update the format. The Cell Inherited style should see that it should be formatted as "C2", don't understand why I have to manually update it.