Hi. I am trying to schedule a marketing cloud visitor ID report through data warehouse and when I get the excel file the ID is converted into a scientific format. I have tried to change format by using "Custom" format in excel however that results in multiple zeroes after a few digits. Also this report will be consumed as it is so can't really edit it every time before it is used. Any suggestions would be welcome.
Thanks for your reply. This file has to be automatically consumed by another team which will not be possible with this solution. Is it going to be the same if the file is scheduled through report builder as well? Any other alternatives?