https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/61566.aspxFri, 19 Nov 2010 18:37:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:61566princevis0https://www.infopathdev.com:443/forums/thread/61566.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=61566<p>You need to keep numeric datatype only, just make sure that the values of characters after decimal should be zero. If that approach wont work, create a calculated column whose value should take only integer values. Let me know if you face some problem....</p>https://www.infopathdev.com:443/forums/thread/61559.aspxFri, 19 Nov 2010 15:06:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:61559Caeanis0https://www.infopathdev.com:443/forums/thread/61559.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=61559<p>I found out how to change the basic data type from number to text, however, the leading zeroes are still being truncated.&nbsp; Is it possible to set up custom data types or set up input masks for a column?<br /></p>https://www.infopathdev.com:443/forums/thread/61522.aspxThu, 18 Nov 2010 15:54:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:61522Caeanis0https://www.infopathdev.com:443/forums/thread/61522.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=61522<p>&nbsp;I have tried creating lists by importing both from an excel spreadsheet and also from an xml file.&nbsp; The problem I&#39;m having is when the data is imported, SharePoint is formating field with leading zeros (like zip code) as regular numbers, so that value 01769 shows up as 1,769.&nbsp; I have specifically gone in and edited the data in the spreadsheet but that is ignored.&nbsp; Do I need to do something special or can I change the data format in the datasheet view in Sharepoint?<br /></p>