custom number format not working

B

BorisS

for some reason, the following enterred into custom format does not work

[>=10000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

whereas this works fine

[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

attempting to accomplish numbering format (format used in India)

Y,YYY,XX,000.0

in other words, at the US 'thousands' break (0 break to X), there is a comma
then the next break between X and Y (hundred more), with another comma (as
opposed to the next thousands break)
then it begins to count like U.S., every three digits

The XX is called 'lakh'
The Y is called "crore"

So what in U.S. would be 10 billion (10,000,000,000) would there be
100,000,00,000 (one hundred thousand crore). I am trying to accomplish this
with custom formatting, but either I'm enterring the wrong formula (note:the
formula for break between 'lakh' and 'crore' (X to Y) does work. It is the
longer one, which tries to force the regular reading of the 'crore' amount,
which says it cannot be understood.

Any help?
 
T

Tyro

[>=10000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

"[>=10000000]" appears twice.

Tyro
 
B

BorisS

true. my mistake. but edited version:

[>=10000000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

gives same message of not being accepted by excel. FYI, I am using 07, and
this is being saved as compatible for 97-03.

Any other ideas?
--
Boris


Tyro said:
[>=10000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

"[>=10000000]" appears twice.

Tyro

BorisS said:
for some reason, the following enterred into custom format does not work

[>=10000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

whereas this works fine

[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

attempting to accomplish numbering format (format used in India)

Y,YYY,XX,000.0

in other words, at the US 'thousands' break (0 break to X), there is a
comma
then the next break between X and Y (hundred more), with another comma (as
opposed to the next thousands break)
then it begins to count like U.S., every three digits

The XX is called 'lakh'
The Y is called "crore"

So what in U.S. would be 10 billion (10,000,000,000) would there be
100,000,00,000 (one hundred thousand crore). I am trying to accomplish
this
with custom formatting, but either I'm enterring the wrong formula
(note:the
formula for break between 'lakh' and 'crore' (X to Y) does work. It is
the
longer one, which tries to force the regular reading of the 'crore'
amount,
which says it cannot be understood.

Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top