| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency vs. Accounting Format | Excel Worksheet Functions | |||
| Currency format not working | Excel Discussion (Misc queries) | |||
| Currency format in sort | Excel Discussion (Misc queries) | |||
| CONVERT DATA TO CURRENCY FORMAT | Excel Discussion (Misc queries) | |||
| how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
Hybrid Mode
