<?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 RE: Error when transfer CSV to XLSX in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Error-when-transfer-CSV-to-XLSX/m-p/47235#M3023</link>
    <description>Hi Kristian,&lt;BR /&gt;&lt;BR /&gt;It looks like Excel is incorrectly interpreting and automatically formatting your data as a date. Here is an article from Microsoft Support on how to address this issue:&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8" target="_blank" rel="noopener"&gt;&lt;STRONG&gt;"Stop automatically changing numbers to dates"&lt;/STRONG&gt;&lt;/A&gt;&lt;BR /&gt;&lt;A href="https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8" target="_blank" rel="noopener"&gt;https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8&lt;/A&gt;&lt;BR /&gt;​&lt;BR /&gt;&lt;A data-tag-text="Excel" data-sign="#" class="user-content-hashtag" href="https://community.blueprism.com/search?s=%23Excel&amp;amp;executesearch=true" data-tag-key="ffde65cb-6c15-4875-a208-efcb380b3128"&gt;#Excel&lt;/A&gt;&lt;BR /&gt;​​&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Patrick Aucoin&lt;BR /&gt;Senior Product Consultant&lt;BR /&gt;Blue Prism&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
    <pubDate>Fri, 02 Oct 2020 15:14:00 GMT</pubDate>
    <dc:creator>PatrickAucoin</dc:creator>
    <dc:date>2020-10-02T15:14:00Z</dc:date>
    <item>
      <title>Error when transfer CSV to XLSX</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Error-when-transfer-CSV-to-XLSX/m-p/47234#M3022</link>
      <description>​Hi Blueprism I have found an error when you transfer from CSV to XLSX file some text will be changed from&lt;BR /&gt;&lt;BR /&gt;3-3044 to 01-03-3044&lt;BR /&gt;&lt;BR /&gt;5-4032 to 01-05-4032&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;
&lt;DIV class="media" style="overflow: hidden; zoom: 1;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="16357.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/16514iDACFC5EA764EB89D/image-size/large?v=v2&amp;amp;px=999" role="button" title="16357.png" alt="16357.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;BR /&gt;&lt;BR /&gt;I have attached a test process where you can replicate the error.&lt;BR /&gt;&lt;BR /&gt;greetings&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Kristian Holm&lt;BR /&gt;RPA programmer&lt;BR /&gt;PenSam (Pension Company)&lt;BR /&gt;Copenhagen Denmark&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Fri, 02 Oct 2020 14:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Error-when-transfer-CSV-to-XLSX/m-p/47234#M3022</guid>
      <dc:creator>KristianHolm1</dc:creator>
      <dc:date>2020-10-02T14:42:00Z</dc:date>
    </item>
    <item>
      <title>RE: Error when transfer CSV to XLSX</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Error-when-transfer-CSV-to-XLSX/m-p/47235#M3023</link>
      <description>Hi Kristian,&lt;BR /&gt;&lt;BR /&gt;It looks like Excel is incorrectly interpreting and automatically formatting your data as a date. Here is an article from Microsoft Support on how to address this issue:&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8" target="_blank" rel="noopener"&gt;&lt;STRONG&gt;"Stop automatically changing numbers to dates"&lt;/STRONG&gt;&lt;/A&gt;&lt;BR /&gt;&lt;A href="https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8" target="_blank" rel="noopener"&gt;https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8&lt;/A&gt;&lt;BR /&gt;​&lt;BR /&gt;&lt;A data-tag-text="Excel" data-sign="#" class="user-content-hashtag" href="https://community.blueprism.com/search?s=%23Excel&amp;amp;executesearch=true" data-tag-key="ffde65cb-6c15-4875-a208-efcb380b3128"&gt;#Excel&lt;/A&gt;&lt;BR /&gt;​​&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Patrick Aucoin&lt;BR /&gt;Senior Product Consultant&lt;BR /&gt;Blue Prism&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Fri, 02 Oct 2020 15:14:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Error-when-transfer-CSV-to-XLSX/m-p/47235#M3023</guid>
      <dc:creator>PatrickAucoin</dc:creator>
      <dc:date>2020-10-02T15:14:00Z</dc:date>
    </item>
  </channel>
</rss>

