I have a text field that contains a number. The number can have up to seven digits, no negatives and no decimal points. The tricky part is that I will be exporting the data to a mainframe system that needs seven digits, so I have to fill in any leading zeros. For example, '23' has to be exported as '0000023'. I want to fill in the zeros when I export because it'll slow down the data entry clerks too much to have to count the zeros and type them in themselves.
So, how can I format the leading zeros? I want to either format the field or have a way to add them in as I output to the text file.