<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Output from Excel to Collection is wrong in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Output-from-Excel-to-Collection-is-wrong/m-p/67811#M20416</link>
    <description>I use the Get Worksheet as Collection MS Excel VBO to extract information from an Excel sheet to a BP collection.

But I have a problem with results from one column showing the wrong value, for example "1,0001E+12" rather than "1000005835442". The problem could be too narrow columns. But by some reason, the real value isn't showed when I expand the column. But the real value is "hidden behind" the cell, and appears in the "fx" textfield. See attached example of what I mean. But the VBO extract the&amp;nbsp;"1,0001E+12" value, rather than "1000005835442" to the BP collection.

Do other experience the same problem, and knows how to solve this issue?

Thanks in advance.

&amp;nbsp;</description>
    <pubDate>Mon, 16 Apr 2018 13:49:00 GMT</pubDate>
    <dc:creator>DennisLaursen</dc:creator>
    <dc:date>2018-04-16T13:49:00Z</dc:date>
    <item>
      <title>Output from Excel to Collection is wrong</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Output-from-Excel-to-Collection-is-wrong/m-p/67811#M20416</link>
      <description>I use the Get Worksheet as Collection MS Excel VBO to extract information from an Excel sheet to a BP collection.

But I have a problem with results from one column showing the wrong value, for example "1,0001E+12" rather than "1000005835442". The problem could be too narrow columns. But by some reason, the real value isn't showed when I expand the column. But the real value is "hidden behind" the cell, and appears in the "fx" textfield. See attached example of what I mean. But the VBO extract the&amp;nbsp;"1,0001E+12" value, rather than "1000005835442" to the BP collection.

Do other experience the same problem, and knows how to solve this issue?

Thanks in advance.

&amp;nbsp;</description>
      <pubDate>Mon, 16 Apr 2018 13:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Output-from-Excel-to-Collection-is-wrong/m-p/67811#M20416</guid>
      <dc:creator>DennisLaursen</dc:creator>
      <dc:date>2018-04-16T13:49:00Z</dc:date>
    </item>
    <item>
      <title>Hi Dennis,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Output-from-Excel-to-Collection-is-wrong/m-p/67812#M20417</link>
      <description>Hi&amp;nbsp;Dennis,
Use Excel VBO - Format Cell Action to resolve the issue.&amp;nbsp;
Regards,
Kirankumar mahanthi.</description>
      <pubDate>Wed, 18 Apr 2018 13:21:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Output-from-Excel-to-Collection-is-wrong/m-p/67812#M20417</guid>
      <dc:creator>KirankumarMahan</dc:creator>
      <dc:date>2018-04-18T13:21:00Z</dc:date>
    </item>
  </channel>
</rss>

