<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Newbie Questions</title><link>https://www.infopathdev.com:443/forums/39.aspx</link><description>New 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.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Null value in submitted form exporting as # value to Excel</title><link>https://www.infopathdev.com:443/forums/thread/65428.aspx</link><pubDate>Thu, 24 Mar 2011 21:51:50 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:65428</guid><dc:creator>AlisonA</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/65428.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=65428</wfw:commentRss><description>&lt;p&gt;I started working with InfoPath earlier this year and created a form that was sent out to users via Outlook and submitted back the same way.&amp;nbsp; The form consists of a drop down box at the top and then various text boxes as control fields.&amp;nbsp;&amp;nbsp;&amp;nbsp;I conditional formatted some of the text boxes to be hidden when certain values in the drop down box are selected because I don&amp;#39;t want&amp;nbsp;users to enter values where they aren&amp;#39;t needed.&amp;nbsp;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;My issue is that for only 1 form out of many that I have received back, a value is popping up for one hidden field in&amp;nbsp;the&amp;nbsp;results when I export them to excel.&amp;nbsp; The field is hidden and the users aren&amp;#39;t able&amp;nbsp;enter anything it in.&amp;nbsp; The value is not a part of the&amp;nbsp;field properites.&amp;nbsp;&amp;nbsp;When I recreate&amp;nbsp;my own version selecting the value in the drop down and fill out other fields and export, the value is not there in the results.&amp;nbsp; It&amp;#39;s&amp;nbsp;a very peculiar thing and I can&amp;#39;t figure out how&amp;nbsp;that value got into the form the user submitted - nor can I figure out how to get it out of the results (besides manually deleting it from the excel cell which is what I&amp;#39;ve reverted to).&amp;nbsp;I am not sure how to &amp;#39;dig&amp;#39; into what the user submitted to get more information.&lt;/p&gt;
&lt;p&gt;I am working with Office 2007.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>