Use the Worksheet_Change Event (in the sheet module) to check for that column.

If not numeric then macro code to right justify, otherwise it will always be left justified.