cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Front 0s in Zipcode

Hello folks,

 

I was wondering how you handle the missing 0's in US Zipcodes?

 

Thank you

 

front zeros zipcode.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Front 0s in Zipcode

Convert the Column to Data Type Text in the Query Editor!

Click the icon on the left side of the Column name and select Text

QE - Data Type Text.png

This should fix it! Smiley Happy

1 REPLY 1
Super User
Super User

Re: Front 0s in Zipcode

Convert the Column to Data Type Text in the Query Editor!

Click the icon on the left side of the Column name and select Text

QE - Data Type Text.png

This should fix it! Smiley Happy