George4Tacks
Level 15

I believe you can format the column with "Format Cells>Special>Zip Code".

If not: Add an extra column with =TEXT(N#, "00000") where N is the column and # is the row number of the cell you want to change. Copy this to each row and it will convert all digits to length 6.

 


Answers are easy. Questions are hard!
0 Cheers