customise grouping of digits in currency format
 

I am using WinXP Home with OfficeXP.

I have selected in WinXP-ControlPanel-date,....Regional Options-change
format of numbers...-Regional Options-Customise-Numbers-digit grouping as
12,34,56,789

However, Excel does not apply this format of digit grouping to any number in
currency format. Is it possible to customise this format in Excel??

R Madhusudanan

customise grouping of digits in currency format
 

Use a custom number format


[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00

will format say 1234567890 as 123,45,67,890.00


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Madhusudanan" wrote in message
...
I am using WinXP Home with OfficeXP.

I have selected in WinXP-ControlPanel-date,....Regional Options-change
format of numbers...-Regional Options-Customise-Numbers-digit grouping as
12,34,56,789

However, Excel does not apply this format of digit grouping to any number
in
currency format. Is it possible to customise this format in Excel??

R Madhusudanan