4 ms·
You already can do that. Albeit it doesn’t detect it as a zip code specifically, but you can format the cells so that values that look like numbers aren’t autom
by hnlmorg 4y ago
You already can do that. Albeit it doesn’t detect it as a zip code specifically, but you can format the cells so that values that look like numbers aren’t automatically converted into numbers.
Excel does have its quirks (CSV handling is one of my pet peeves) but it does also have a surprising amount of sophisticated adjustable logic that is often hidden in plain sight.
- xnx 4y agoDefinitely. I wish there was a global/permanent setting to not strip leading zeros. I imagine the design decision might have been made decades ago for Lotus 1-2-3 compatibility or something, but it's almost certainly cost much more time and mistakes than it has saved.
- trekkie1024 4y agoThis might be the setting you're looking for? https://www.howtogeek.com/816620/microsoft-is-finally-fixing-excels-data-conversion-problem/ https://www.howtogeek.com/816620/microsoft-is-finally-fixing...