I have an excel sheet where a certain column has a Percentage format. However, when imported to VA, the data returns as Character (all other data values from the excel sheet remains like date except for this one). The funny thing, I have been using, updating and importing the same excel sheet for 3 months in my VA weekly report and had this trouble started only two days ago. I used a different excel file and when imported to VA identifies a numeric column in excel as category in VA. Tried the following but nothing worked: 1. Clear cache, use other browser 2. Copy the values to a new Excel sheet and save/import as CSV Help!
... View more