That is because the creator of ZIP codes lived in New England, and the ZIP codes start in his mom's home town. Perhaps real, perhaps apocryphal, but a nice story. Don't get me started on diagnosis codes where both leading and trailing decimal zeros are meaningful. 0.00 iand 0 and 0.0 are different (weeping) Anyway, another option is for the client to format that column as "Zip", an option withing "Format Cells" in Excel. Or damn the USPS for using all 10 digits and creating > 10 regions, with region zero (0) being New England. > > -- > Robert Heller -- 978-544-6933 > Deepwoods Software -- Custom Software Services -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20160623/2e8ee3c4/attachment.html