customise grouping of digits in currency format

[Guest]

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

 

[Bob Phillips]

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)