The Regional Settings location is chosen on the first tab (called Regional Settings) of the Control Panel's Regional Settings applet, and it defines:
□ The day and month names shown in Excel cells for long date formats
□ The day and month names returned by the VBA Format function
□ The month names recognized by the VBA CDate function and when typing dates into Excel directly
□ The month names recognized by the Text Import Wizard and the VBA OpenText method (when the Local parameter is True)
□ The number format characters used in the =TEXT worksheet function
□ The text resulting from the implicit conversion of Boolean values to strings, such as: "I am " & True
Was this article helpful?