DOLLAR
Converts a number to a string representing the amount in the currency format, rounded to a specified decimal places, using the decimal separator that corresponds to the current locale setting. In the Value field enter the number to be converted. Optionally, you may enter the number of decimal places in the Decimals field. If no value is specified, all numbers in currency format will be displayed with two decimal places.
āĻāĻĒāĻ¨āĻžāĻ° āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽā§āĻ° āĻ¸ā§āĻāĻŋāĻā§ā§ āĻāĻĒāĻ¨āĻŋ āĻŽā§āĻĻā§āĻ°āĻžāĻ° āĻŦāĻŋāĻ¨ā§āĻ¯āĻžāĻ¸ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻāĻ°ā§āĻ¨āĨ¤
DOLLAR(Value [; Decimals])
Value āĻšāĻ˛ā§ āĻāĻāĻāĻŋ āĻ¸āĻāĻā§āĻ¯āĻž, āĻ¸āĻāĻā§āĻ¯āĻž āĻ°ā§ā§āĻā§ āĻāĻŽāĻ¨ āĻāĻāĻāĻŋ āĻāĻ°ā§āĻ° āĻ°ā§āĻĢāĻžāĻ°ā§āĻ¨ā§āĻ¸, āĻŦāĻž āĻ¸āĻāĻā§āĻ¯āĻž āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§ āĻāĻŽāĻ¨ āĻāĻāĻāĻŋ āĻ¸ā§āĻ¤ā§āĻ°āĨ¤
āĻĻāĻļāĻŽāĻŋāĻ āĻšāĻ˛ā§ āĻĻāĻļāĻŽāĻŋāĻ āĻ¸ā§āĻĨāĻžāĻ¨ā§āĻ° āĻāĻā§āĻāĻŋāĻ āĻ¸āĻāĻā§āĻ¯āĻžāĨ¤
=DOLLAR(255) returns $255.00 for the English (USA) locale and USD (dollar) currency; īŋĨ255.00 for the Japanese locale and JPY (yen) currency; or 255,00 âŦ for the German (Germany) locale and EUR (euro) currency.
=DOLLAR(367.456;2) returns $367.46.
