Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But still I could not able to use the update changes setting in digit group. How can I use my update digit group setting. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Montu,
Use a custom format of [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Montu" wrote in message ... I have change the setting of digt group under Number & Curency tab in regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But still I could not able to use the update changes setting in digit group. How can I use my update digit group setting. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you for your suggestion. I knew about custom format. I just want to
know what is the utility of change the setting of digit group in regional setting in control panel. Would you tell me what is the process to work in change setting of digit group or Is there any way to work as per my setting instead of custom format. Thanks in advance "Bob Phillips" wrote: Montu, Use a custom format of [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Montu" wrote in message ... I have change the setting of digt group under Number & Curency tab in regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But still I could not able to use the update changes setting in digit group. How can I use my update digit group setting. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It's under Digit Grouping.
On Dec 21, 12:19 am, Montu wrote: Thank you for your suggestion. I knew about custom format. I just want to know what is the utility of change the setting of digit group in regional setting in control panel. Would you tell me what is the process to work in change setting of digit group or Is there any way to work as per my setting instead of custom format. Thanks in advance "Bob Phillips" wrote: Montu, Use a custom format of [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Montu" wrote in message ... I have change the setting of digt group under Number & Curency tab in regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But still I could not able to use the update changes setting in digit group. How can I use my update digit group setting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dropdown entry seperator question for Excel XP? | Excel Discussion (Misc queries) | |||
Excel 2002 -Merging cells contents in with a comma seperator | Excel Discussion (Misc queries) | |||
1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
Thousand Seperator | Excel Discussion (Misc queries) |