Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I am using Excel to look at my downloaded Dashboard statistics, but the eBay Listing ID isn displayed properly. How can I fix this?

April 26, 2017dashboard downloaded eBay Excel Id listing look properly statistics

0

Posted

I am using Excel to look at my downloaded Dashboard statistics, but the eBay Listing ID isn displayed properly. How can I fix this?

1 Answer

0

Posted

The eBay download file is an Excel file. Unfortunately, Excel does not always read the eBay listing ID properly. To fix the problem with the eBay Listing ID, you need to change the format of the cells. To do this, select the column titled ‘eBay Listing ID’. Then choose the ‘Format’ from the top menu in Excel and choose the ‘Cells’ option. In the small ‘Format Cells’ window that pops up, make sure you can see the ‘Number’ tab, which contains a list headed ‘Category’. Choose ‘Number’ from this list and you will see more options appear. In the ‘Decimal places’ section, choose ‘0’, either by typing the number in directly or using the arrows. Finally, click the ‘OK’ button to confirm the format. The eBay Listing ID should now be in the correct format.