Live Chat Software by Kayako |
Knowledgebase
How to: Fix display when Excel Reports don't display in columns
Posted by Bruce Kamm on February 09 2015 05:44 AM
|
|
In the new versions of Excel, the default delimiter is now a comma. In order to display reports downloaded from vBarter in Excel format in columns, the Delimiter setting in Excel must be changed from a comma to a colon. In Excel, Select Text on the Data Tab Then, select Delimited and click Next Set your delimited to Other and enter a colon : in the text box. Click Next and then Finish. Once the setting is changed, downloaded reports in Excel format should display in columns.
| |
|
Comments (0)