FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   Sign UpSign Up  
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Importing data with leading Zeros in the Zip code field

 
Post new topic   Reply to topic    IQServices.com Support Forum Forum Index -> Xtreme Locator Frequently Asked Questions
View previous topic :: View next topic  
Author Message
d2pc



Joined: 06 May 2004
Posts: 106
Location: MI, USA

PostPosted: Tue Mar 18, 2008 8:33 am    Post subject: Importing data with leading Zeros in the Zip code field Reply with quote

If you are loosing the leading zeros in Zip code this is because your spreadsheet program is thinking that this is a number field. you need to force it to see this field as a text field.
Use .xls format and highlight the "Zip" column and select the format as text. This will allow that field to retain the leading zero.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    IQServices.com Support Forum Forum Index -> Xtreme Locator Frequently Asked Questions All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Copyright © 2004 IQ Services, All Rights Reserved