I have a column that requires 5 numbers:

I want to prefix with zeros any number that doesn't meet the required 5
digits.


Is there a way to format the column with this structure and in the future if
the file is modifed that it will automatically adjust the column, so that if
someone types in:

123 that the result would be 00123
or
1234 then the result would be 01234

How can I accomplish this?

Thank you.