Geography Data Type with Zip Codes Not Working? Try This Instead! 🔥 [EXCEL TIPS]

In this viewer question video we answer Ameed's question about why the Geography Data type with his New Jersey zip code lists might not be working. The Geo data type can be really hepful, but it doesn't always get things correct. In this video we'll troubleshoot using the New Jersey zip codes with leading 0's and show an alternative way to grab info like city and state from a zip code in Excel (we'll use the USPS zip code database a few handy XLOOKUP functions). Follow along and let me know how you've used the Geo data type in comments below.

------------------------------
⌚ *Timestamps*
------------------------------
00:00 Ameen's Question about Geography Data Type
00:24 Change Number to Text Cell Format
01:00 Geography Data Type in Excel
02:20 FIELD errors in Geography Data Type in Excel
03:01 Use XLOOKUP to get City and State from Zip Code

------------------------------
📣 *Shoutouts*
------------------------------

---------------------------------
▶️ *Related Videos*
---------------------------------

-------------------------------------------
💻 *Template Downloads*
-------------------------------------------

------------------------------------------
🙏 *Support My Channel*
------------------------------------------
HIT the SUPER THANKS 💗 button on any video!

-----------------------------------------
🎒 *Courses & Affiliates*
-----------------------------------------

------------------
🙋 *FAQs*
------------------
I’m using Microsoft 365 in my videos: PowerPoint, Excel, Word. If you don't have a feature you see here, check the Microsoft support pages for a version feature list
Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel.

#viewerquestion #excel #exceltips