ECID formating while exporting data | Adobe Higher Education
Skip to main content
R
RohitNa1
Level 2
August 14, 2024
Question

ECID formating while exporting data

Hi, i am trying to explore ecid data in excel however am not getting ecid data in correct format its captured as scietific format and making it to number format removes all valid number to zero.

 

let me know if there is a work around

Ce sujet a été fermé aux réponses.

2 commentaires

Isha Gupta
Community Advisor and Adobe Champion
Isha GuptaCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
August 14, 2024

Hi @rohitna1 ,

If you are downloading from Workspace report, while opening the document, click don't convert. If that doesn't work, change the cell format to text and this should preserve the values in original state.

    R
    RohitNa1Auteur
    Level 2
    August 19, 2024

    Thanks would you have a screenshot on the same.

    Josh Stephens
    Community Advisor
    Josh StephensCommunity Advisor
    Community Advisor
    August 14, 2024

    Hi @rohitna1 If you're using Excel, there's now a setting  that will disable this indefinitely.  On PC, these are under File > Options > Data > Automatic Data Conversion. 

     

     

     

      R
      RohitNa1Auteur
      Level 2
      August 19, 2024

      Not sure why I could not find this option in my excel, Thanks for this though.

      Conditions d'utilisationAccessibility statement

      Loading footer...