George4Tacks
Level 15
08-24-2020
12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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!