Hello Mani,

In English-language Excel the equivalent function is DOLLAR, another

possibility is FIXED

Syntax

DOLLAR(number,decimals)

Converts a number to text using currency format, with the decimals rounded

to the specified place. The format used is $#,##0.00_);($#,##0.00).

Number is a number, a reference to a cell containing a number, or a

formula that evaluates to a number.

Decimals is the number of digits to the right of the decimal point. If

decimals is negative, number is rounded to the left of the decimal point. If

you omit decimals, it is assumed to be 2.

Syntax

FIXED(number,decimals,no_commas)

Number is the number you want to round and convert to text.

Decimals is the number of digits to the right of the decimal point.

No_commas is a logical value that, if TRUE, prevents FIXED from including

commas in the returned text. If no_commas is FALSE or omitted, then the

returned text includes commas as usual.

.. Numbers in Microsoft Excel can never have more than 15 significant digits,

but decimals can be as large as 127.

.. If decimals is negative, number is rounded to the left of the decimal

point.

.. If you omit decimals, it is assumed to be 2.

Cheers