Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patters of numbers in cell
Sir ,
i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patters of numbers in cell
Format as Custom, #\,##\,###.00
"eereokatohar" wrote: Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patters of numbers in cell
[=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
Bob,
Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
Epinn,
Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?"
Epinn "Bob Phillips" wrote in message ... Epinn, Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
I found out two regions use this format - India and Thailand. I read BAHTTEXT( ) via Excel Help. Interesting indeed.
What is the equivalent function for US$? Epinn "Epinn" wrote in message ... Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?" Epinn "Bob Phillips" wrote in message ... Epinn, Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
123,456,789 of course, as it is for UK and most of the world.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... I found out two regions use this format - India and Thailand. I read BAHTTEXT( ) via Excel Help. Interesting indeed. What is the equivalent function for US$? Epinn "Epinn" wrote in message ... Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?" Epinn "Bob Phillips" wrote in message ... Epinn, Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
Yes, I know 123,456,789 is the *format* for most of the world. But I was asking for the *function* that is equivalent to BAHTTEXT( ) which converts the numbers to words.
Is there one? Need a macro? It will be interesting if we don't have a function for most of the world but have one for the Baht users. Epinn "Bob Phillips" wrote in message ... 123,456,789 of course, as it is for UK and most of the world. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... I found out two regions use this format - India and Thailand. I read BAHTTEXT( ) via Excel Help. Interesting indeed. What is the equivalent function for US$? Epinn "Epinn" wrote in message ... Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?" Epinn "Bob Phillips" wrote in message ... Epinn, Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Grouping patterns of numbers in cell
Aah, sorry, misunderstood. Yes it needs code.
See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Yes, I know 123,456,789 is the *format* for most of the world. But I was asking for the *function* that is equivalent to BAHTTEXT( ) which converts the numbers to words. Is there one? Need a macro? It will be interesting if we don't have a function for most of the world but have one for the Baht users. Epinn "Bob Phillips" wrote in message ... 123,456,789 of course, as it is for UK and most of the world. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... I found out two regions use this format - India and Thailand. I read BAHTTEXT( ) via Excel Help. Interesting indeed. What is the equivalent function for US$? Epinn "Epinn" wrote in message ... Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?" Epinn "Bob Phillips" wrote in message ... Epinn, Interesting it is. Unlike you, I threw caution to the wind and selected it. It didn't seem to do anything, when I selected the comma style or currency style from the formatting toolbar, I still got 123,456,789 format. I wonder if you also need some language pack or something. I think I will do some more investigations. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... Bob, Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right? If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from. Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;) Epinn "Bob Phillips" wrote in message ... [=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) "eereokatohar" wrote in message ... Sir , i want to numbers written in cells be displayed as grouped in indian format i.e. a number of 123456.00 can how be automatically group as 1,23,456.00 instead of 123,456.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum numbers thru specifying the amount from another cell? | Excel Discussion (Misc queries) | |||
Is this possible ??? | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Extract numbers from cell with Text and Numbers | New Users to Excel | |||
create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) |