Excel digit grouping for Dollars & Cents and Rupees & paises.

Excel digit grouping for Dollars & Cents and Rupees & Paises.. Choose this in Format Cells Tab, Custom Option.

*******************************************************
Dollars with Three Digit Grouping:
1,234,567,890
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

1,234,567,890.00
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

$1,234,567,890
_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)

$1,234,567,890.00
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
*******************************************************
Rupees with Two Digit Grouping:
1,23,45,67,890
_ * #,##0_ ;_ * -#,##0_ ;_ * "-"_ ;_ @_

1,23,45,67,890.00
_ * #,##0.00_ ;_ * -#,##0.00_ ;_ * "-"??_ ;_ @_

₹ 1,23,45,67,890
_ ₹\ * #,##0_ ;_ ₹\ * -#,##0_ ;_ ₹\ * "-"_ ;_ @_

₹ 1,23,45,67,890.00
_ ₹\ * #,##0.00_ ;_ ₹\ * -#,##0.00_ ;_ ₹\ * "-"??_ ;_ @_
*******************************************************