Knowledgebase: How To's
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))
Helpful
Not helpful

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