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

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

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

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

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

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

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

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

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

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