Apply MS Excel Formats to Attribute Values

Working with CSV Text Files to Upload Data : Creating a CSV Text File from an MS Excel Spreadsheet : Apply MS Excel Formats to Attribute Values

Apply MS Excel Formats to Attribute Values

Apply a text format to the columns of attributes that appear numeric but must be shown as text.

MS Excel interprets the values in the columns; if they appear to be numeric, it removes leading zeros and may display the value in exponential format. This will cause problems in the CSV text file because all of the characters are important in attributes such as Selection Codes, Products, and GTINs. To prevent numbers from being truncated, these cells must be formatted as text.

1

On the spreadsheet you created above, select the following columns: SELCODE, PRODUCT, and ITEM_NUMBER (use Ctrl-click to select multiple columns).

2

Right-click on a cell and select Format Cells.

3

Click the Number tab and select Text from the Category list.

4

Click OK.

The text format is applied to the selected columns.

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF