<?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: Report Builder keeps formatting numbers in Scientific/Text format in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246415#M807</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The challenge is indeed an excel one. The Adobe report builder data blocks when refreshed/or newly added automatically kill any previous custom formatting exel formatting, they also are indeed limited to excels limitations. In terms of report builder options there is no solution for scheduled reports.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What you may be able to do is use data warehouse for the formatting challenged sections. The challenge here is report builder can do many sectioned report-lets in one doc, while data warehouse is limited to one report per scheduled report-let. Its not a clean easy one doc solution, but in theory would work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;gltu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 11 Sep 2018 14:25:32 GMT</pubDate>
    <dc:creator>Pablo_Childe</dc:creator>
    <dc:date>2018-09-11T14:25:32Z</dc:date>
    <item>
      <title>Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246414#M806</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello -&lt;/P&gt;&lt;P&gt;In my reports I have to report on confidence level that uses decimal number, which is not standardized and can get very long. In the report the number of decimals higher than 13 decimals gets converted to Scientific/Text format. I can manually change these types of numbers to number/generic format, and if I refresh report manually RB keeps the number/generic format. However, the scheduled report keeps reversing the numbers back to the Scientific/Text format. I spoke to Adobe client care they said that this is an excel limitation as the cell should display no more than 11 digits in the General format. I tried formatting, formulas and was not able to find any solution yet. Do you have any suggestions for me? Thanks in advance!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 10 Sep 2018 15:15:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246414#M806</guid>
      <dc:creator>nataljaz4307690</dc:creator>
      <dc:date>2018-09-10T15:15:01Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246415#M807</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The challenge is indeed an excel one. The Adobe report builder data blocks when refreshed/or newly added automatically kill any previous custom formatting exel formatting, they also are indeed limited to excels limitations. In terms of report builder options there is no solution for scheduled reports.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What you may be able to do is use data warehouse for the formatting challenged sections. The challenge here is report builder can do many sectioned report-lets in one doc, while data warehouse is limited to one report per scheduled report-let. Its not a clean easy one doc solution, but in theory would work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;gltu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 11 Sep 2018 14:25:32 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246415#M807</guid>
      <dc:creator>Pablo_Childe</dc:creator>
      <dc:date>2018-09-11T14:25:32Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246416#M808</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Appreciate the suggestion!&lt;/P&gt;&lt;P&gt;This data is a part of a bigger automated report. I am trying to avoid any manual manipulations and am looking for possible ways to adjust the formatting automatically most likely by excel formulas.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Nat&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 11 Sep 2018 16:04:03 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246416#M808</guid>
      <dc:creator>nataljaz4307690</dc:creator>
      <dc:date>2018-09-11T16:04:03Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246417#M809</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Then I am sad to say you no real option, you could reduce the decimals to excels limitation...(but I am guessing that is not ideal)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Other than that there is no simple automatic solution.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;regards&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Pablo&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 11 Sep 2018 18:15:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246417#M809</guid>
      <dc:creator>Pablo_Childe</dc:creator>
      <dc:date>2018-09-11T18:15:46Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246418#M810</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thank you, Pablo!&lt;/P&gt;&lt;P&gt;Yes, I am working with IT to see, if they can change the digits number from the back end.&lt;/P&gt;&lt;P&gt;Thank you again for the feedback!&lt;/P&gt;&lt;P&gt;Nat&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 11 Sep 2018 18:40:39 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246418#M810</guid>
      <dc:creator>nataljaz4307690</dc:creator>
      <dc:date>2018-09-11T18:40:39Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246419#M811</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You can try one more thing. Prepend the text with a single quote.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If this is an event, click on the &lt;SPAN style="text-decoration: underline;"&gt;None&lt;/SPAN&gt; besides it&lt;/P&gt;&lt;P&gt;In the context menu select 'Prepend/Postpend Text'.&lt;/P&gt;&lt;P&gt;In the first box, enter a single quote. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="1570614_pastedImage_3.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/13415iDB7C5F1DB94B8140/image-size/large?v=v2&amp;amp;px=999" role="button" title="1570614_pastedImage_3.png" alt="1570614_pastedImage_3.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="1570613_pastedImage_1.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/13416i9B0DFB9CD38ABE04/image-size/large?v=v2&amp;amp;px=999" role="button" title="1570613_pastedImage_1.png" alt="1570613_pastedImage_1.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This will make Excel not change the number to scientific format, and also Excel by default hides the single quote if starting with a single quote.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 13 Sep 2018 05:25:35 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246419#M811</guid>
      <dc:creator>Hyder_Ziaee</dc:creator>
      <dc:date>2018-09-13T05:25:35Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246420#M812</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello -&lt;/P&gt;&lt;P&gt;Thank you so much for looking into it. Per your suggestion I tried&lt;/P&gt;&lt;P&gt;'Prepend/Postpend&lt;/P&gt;&lt;P&gt;Text' in RB. For some reason it did the opposite. I originally set&lt;/P&gt;&lt;P&gt;formatting for this data block to remove scientific/text formatting. When I&lt;/P&gt;&lt;P&gt;added single quote and refreshed the data block manually all numbers turned&lt;/P&gt;&lt;P&gt;back into and  scientific/text format.  This is why I honestly think that&lt;/P&gt;&lt;P&gt;this is RB functionality issue and not Excel.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you so much for your help!  Also special thanks for showing me&lt;/P&gt;&lt;P&gt;the 'Prepend/Postpend&lt;/P&gt;&lt;P&gt;Text' in RB, I did not notice this functionality before.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Nat&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;After - this is how it looks like with the "prepended" single quote.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Before&lt;/STRONG&gt;* - this is how the data looks like with the set formatting&lt;/P&gt;&lt;P&gt;(removing text/scientific formatting) refreshing *&lt;STRONG&gt;manually&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;On Thu, Sep 13, 2018 at 1:25 AM, hyderziaee &amp;lt;forums_noreply@adobe.com&amp;gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 14 Sep 2018 14:14:13 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246420#M812</guid>
      <dc:creator>nataljaz4307690</dc:creator>
      <dc:date>2018-09-14T14:14:13Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246421#M813</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I don't see the images if there were any in the response. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you try keeping the formatting to default, not text, and then try the single quote solution?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Sep 2018 04:41:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246421#M813</guid>
      <dc:creator>Hyder_Ziaee</dc:creator>
      <dc:date>2018-09-19T04:41:42Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246422#M814</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I frequently find that it takes a couple tries for Excel formatting to work. A lot of times I'll get almost all my data requests in date format for some reason. Try this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Format the cells the way that you want them to&lt;/LI&gt;&lt;LI&gt;Schedule it to be sent to yourself immediately&lt;/LI&gt;&lt;LI&gt;When the workbook arrives, open it, and you might see that the formatted cells aren't correctly formatted anymore&lt;/LI&gt;&lt;LI&gt;Using this emailed workbook, set the formatted cells to the way you want them again&lt;/LI&gt;&lt;LI&gt;Reschedule the emailed workbook (and not the original one) to be sent to yourself again&lt;/LI&gt;&lt;LI&gt;If your experience is the same as mine, the cell formatting should stick now&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Let me know if this works for you!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Sep 2018 23:59:35 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246422#M814</guid>
      <dc:creator>Gigazelle</dc:creator>
      <dc:date>2018-09-21T23:59:35Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246423#M815</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Natalja, were you able to get this resolved?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 27 Sep 2018 00:02:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/246423#M815</guid>
      <dc:creator>Gigazelle</dc:creator>
      <dc:date>2018-09-27T00:02:17Z</dc:date>
    </item>
    <item>
      <title>Re: Report Builder keeps formatting numbers in Scientific/Text format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/416352#M2807</link>
      <description>&lt;P&gt;&lt;LI-USER uid="13934227"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;P&gt;Change the Scientific notation Format as text.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Prepend&amp;nbsp; text single quote(‘).&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Postpend text leave it as Blank.&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kirang29990284_1-1626672611184.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/33117i21D1C5CACA721257/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="kirang29990284_1-1626672611184.png" alt="kirang29990284_1-1626672611184.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kirang29990284_2-1626672715601.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/33118i48FA4EFB669F85EB/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="kirang29990284_2-1626672715601.png" alt="kirang29990284_2-1626672715601.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Follow like as shown in the screen shot. you will get the complete numbers while receving reports as scheduled.&lt;/P&gt;&lt;P&gt;Kiran&lt;/P&gt;</description>
      <pubDate>Mon, 19 Jul 2021 05:33:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/report-builder-keeps-formatting-numbers-in-scientific-text/m-p/416352#M2807</guid>
      <dc:creator>kirang29990284</dc:creator>
      <dc:date>2021-07-19T05:33:28Z</dc:date>
    </item>
  </channel>
</rss>

