Microsoft KB Archive/924624

= Array constants may unexpectedly contain backslash characters in Excel 2007 or in Excel 2003 =

Article ID: 924624

Article Last Modified on 5/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Office Excel 2007

-



SYMPTOMS
Array constants may unexpectedly contain backslash (\) characters in Microsoft Office Excel 2007 or in Microsoft Office Excel 2003.



CAUSE
This issue may occur when period (.) characters or semicolon characters in the array create a symbol conflict.

In Excel 2007 and in Excel 2003, the following format is used for array constants:
 * Array constants are enclosed in braces ( { } ).
 * Column separators are indicated by the period character.
 * Row separators are indicated by the semicolon character.



WORKAROUND
When you open a document that contains array constants, symbols are automatically modified. Therefore, to work around this issue, use a backslash (\) character as the new row separator or column separator for any new array constants you create.

