The only way I can think of doing this is with a macro. One cell calls a macro with the range for the whole column. Then, when the column changes (insert, edit, etc.), the macro then runs and renumbers the column.