How do I ensure that the downloaded values display properly in MS Excel?
Downloaded files from AAD are CSV files and may be opened with MS Excel. The default column format in MS Excel is “general” which converts numeric values to numbers, date values to dates, and all remaining values to text. Sometimes, the “general” format will cause values to incorrectly display. The following instructions will prevent this from occurring.
Related Questions
- I am using Excel to look at my downloaded Dashboard statistics, but the eBay Listing ID isn displayed properly. How can I fix this?
- Id like to learn some new ways of manipulating the MS Excel data that I downloaded from BEN Reports, is there a training session?
- How do I ensure that the downloaded values display properly in MS Excel?