A sales spreadsheet has postal codes such as 00123. Automatic detection treats the field as numeric and removes leading zeros. What should the analyst do?

1. Round postal codes to the nearest hundred
2. Set the postal-code column to an appropriate text attribute
3. Sum postal codes as a measure
4. Replace all missing codes with the average code