Grouping patters of numbers in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
[>=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)
 
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


[>=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)
 
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)

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


[>=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)
 
Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?"

Epinn

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)

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


[>=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)
 
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

Forgive me if this is a dumb question. Do we have to reboot after clicking "apply?"

Epinn

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)

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


[>=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)
 
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)

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

Forgive me if this is a dumb question. Do we have to reboot after clicking
"apply?"

Epinn

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)

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


[>=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)
 
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

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)

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

Forgive me if this is a dumb question. Do we have to reboot after clicking
"apply?"

Epinn

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)

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


[>=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)
 
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)

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

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)

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

Forgive me if this is a dumb question. Do we have to reboot after clicking
"apply?"

Epinn

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)

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


[>=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)
 
Back
Top