I've got a column, say column Z of a csv file, that contains zip code info. Most contain zip plus 4 (Formatted 000000000) but some contain just the zip (formatted 00000). I'd like to add to an existing VBA function a little section that checks the column, and wherever the zip is five digits, it adds four 0's to the back end. Any recommendations?