3 ms·

> Zip code ... maybe ... if you are US only. Otherwise a postcode can't be parsed either. Also, don't store zip code as an integer. There are valid zip codes

> Zip code ... maybe ... if you are US only. Otherwise a postcode can't be parsed either. Also, don't store zip code as an integer. There are valid zip codes that start with zero that will likely get truncated if you store a zip code as an integer.

wombatpm 6y ago
Excel being helpful that way has been the Bain of my existence
- jdsully 6y ago
  Set the type of the cell to text: 1 Highlight cell, or range/column 2 ctrl+1 or right click + format cells 3 select text from the type combo box