ECID formating while exporting data | Community
Skip to main content
Level 2
August 14, 2024
Question

ECID formating while exporting data

  • August 14, 2024
  • 2 replies
  • 837 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Isha Gupta
Community 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.

RohitNa1Author
Level 2
August 19, 2024

Thanks would you have a screenshot on the same.

Josh Stephens
Community 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. 

 

 

 

RohitNa1Author
Level 2
August 19, 2024

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