leetmilf
New Member
- Joined
- Aug 31, 2014
- Messages
- 10
There are hundreds of topics on leading zeros - I've searched several and can't quite get the answer I am looking for - so I apologize in advance for potentially repeating a topic.
A few months back I posted a similar topic but the answers do not apply in this situation.
I'm making a zip +4 to locality tool. Basically - each zip code returns a locality of 1 or 99. However, there are certain zip codes that require zip+4 to get the actual locality. I've created a simple tool for processors to enter the zip code. Below notice the function for the 2014 tool:
If the locality returns #N/A they are to then enter the +4. (I will soon put a conditional formatting on there to further reduce confusion, but for now this is as far as I've gotten)
I have the 2015 tool ready to go(as far as I know - anyway...no truncated leading zero situations)
the 2014 tool is giving me issues.
I used a helper column to match the zip code and plus 4 cells. I've tried everything - and the helper column is dropping leading zeros from the PLUS 4 cell.:
I've tried custom formatting, apostrophes, converting fields to text, converting fields to zip code, etc. I'm about to throw my computer out the window, seriously. How do I get the helper column to KEEP the leading zeros? I have about 38k rows and I honest do not want to go through adding 0's, because the next file I make is for another dept and includes all 50 states....this is just for the state of MI.
A few months back I posted a similar topic but the answers do not apply in this situation.
I'm making a zip +4 to locality tool. Basically - each zip code returns a locality of 1 or 99. However, there are certain zip codes that require zip+4 to get the actual locality. I've created a simple tool for processors to enter the zip code. Below notice the function for the 2014 tool:
If the locality returns #N/A they are to then enter the +4. (I will soon put a conditional formatting on there to further reduce confusion, but for now this is as far as I've gotten)
I have the 2015 tool ready to go(as far as I know - anyway...no truncated leading zero situations)
the 2014 tool is giving me issues.
I used a helper column to match the zip code and plus 4 cells. I've tried everything - and the helper column is dropping leading zeros from the PLUS 4 cell.:
I've tried custom formatting, apostrophes, converting fields to text, converting fields to zip code, etc. I'm about to throw my computer out the window, seriously. How do I get the helper column to KEEP the leading zeros? I have about 38k rows and I honest do not want to go through adding 0's, because the next file I make is for another dept and includes all 50 states....this is just for the state of MI.