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.



(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).