Syntax and Parameters

The VExtenso () is an only function that receives monetary or numerical a value and returns this value written for extensive.

Syntax:
= VExtenso (value [; currency] [; language])

Parameters	Description
value	Obligator. A numerical or monetary value, with precision of up to two decimal houses. Former: R$ 1,456, 12
currency	Optional. If omitted, it searchs currency in agreement Regional Configurations. REAL, EURO or DOLLAR.
language	Optional. If omitted, it searchs language in agreement Regional Configurations. BR, PT or US.

VALUE

This parameter is obligator. Its value must be a valid numerical value, or a valid monetary value (including or not it symbol of the currency). This also accepted parameter some texts special, written in very small letters. It sees below:   

Although the function to accept numerical values with number of decimal houses bigger that two, the two first ones will only be considered and the rounding will be made in accordance with the banking standard. Exactly thus, the use of two decimal houses sends regards (remembering that Excel can be configured to show two houses, but it sends regards that the internal value is of two houses).

CURRENCY

The following options daily pay-are configured:

When passing as parameter of the function, these values must be between quotations marks, or then inside of a cell of planinha. Not to show no unit, you it can pass a blank space for the function. The function also allows, inside of its limitations, to pass the customizado parameter of currency, as for example “meter”, “liter”, “thing”, “item”, etc. This option still will be perfected following its suggestions. Soon more daily pay-configured currencies. If omitted, the currency will be consulted on the basis of the Regional Configurations of the Windows.

LANGUAGE

When passing as parameter of the function, these values must be between quotations marks, or then inside of a cell of planinha. The language of the value for extensive will be determined by this configuration, or then, it will have forborn, it will be determined through the Regional Configurations of the Windows.

Important comments:

• When the function determines the language or the currency through the Regional Configurations, it takes in account the language selected in this screen, and not it Layout of Keyboard, that can be any one.
• If a spread sheet will be created in a station of work with the Regional Configurations for Portuguese of Portugal and the parameters will be omitted, the function will fill these configurations in accordance with. After to be salute, the spread sheet could be visualized in any another station, does not import which the Regional Configuration. However, the values that will be modified will be sobrescritos in agreement the configurations of the station.
• The VExtenso function does not need to be installed if the spread sheet alone will be visualized; but it must be present case its values will be modified. In such a way you to send its spread sheets also for email for other people, since whom they do not need to modify its content.