ECID formating while exporting data

[RohitNa1]

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

[Isha__Gupta]

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.

[RohitNa1]

Thanks would you have a screenshot on the same.

[Josh__Stephens]

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. 

[RohitNa1]

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