Numerical Configuration Name

If a configuration name in a design table contains only numbers, Excel interprets the name as a numeric value, instead of text. This is not a problem, except in the following cases:

  • If the value begins with zeroes, the leading zeroes are removed.
  • If the value is more than 12 characters long, it is displayed in scientific notation.

To correct the problem, right-click the header cell for column A (to select the whole column), and select Format Cells. On the Number tab, under Category, select Text.