https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/100036.aspxWed, 12 Nov 2014 23:09:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100036Sparky000https://www.infopathdev.com:443/forums/thread/100036.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=100036<p>Hello experts,</p><p>We have a Sharepoint 2013 farm, and I&#39;ve been playing with Infopath 2013 the past couple of weeks. What I&#39;d like to do is to have a form that retrieves some values from a published Excel workbook.</p><p>I&#39;ve added the data connections (SOAP) to the form and I&#39;m able to retrieve values (GetCellA1 operation). However there is currently one problem that I can&#39;t seem to figure out. The Excel workbook has a cell with date value in it. When this value is retrieved to the Infopath form, it shows up as a 5-digit integer. This integer is equal to the cell&#39;s value formatted as General in the Excel workbook. For example: if date is 12/22/2014, then the integer is 41995, and 41995 is what shows up in the Infopath form. I&#39;ve made sure the field has been set to Date format.</p><p>Can anyone land a hand? Thanks! <br /></p>