the modified custom format is
[=10000000]##\,##\,##\,##0.00;##,##0.00

this gives 122245678 as
12,22,45,678.00



R.VENKATARAMAN $$$ wrote in message news:...
as I said in the message this is for lakhs(an indian system of
arithmetic).
you can MODIFY that for crores(the next level to lakh in indian system)
ie.
10 crores 28 lakhs 45thousand 678.


IanRoy wrote in message
...
Hi, All;
Curious, I tried this. Custom format [=100000]##\,##\,##0;##,##0 gave
me
1028,45,678 instead of 10,28,45,678. AutoSum worked on it, though.
Adding
two
of them gave me 2056,91,356. Excel treats these as numbers. It is wise
to
avoid provincial assumptions about other peoples' number formats, and
refrain
from blanket negatives about Excel. ;)
Regards,
Ian.

"Oliver Ferns via OfficeKB.com" wrote:

In short, you can't. Why? Because '10,28,45,678'is not a number.
However,
were you to start the cell entry with an apostrophe "'" then you can
achieve the effect of 10,28,45,678. Excel will not be able to perform
numerical calculations on this cell.


Hth,
Oli

--
Message posted via http://www.officekb.com

I stand (sit?) corrected. I did try to achieve this through custom formats
but with no joy. It seems I have much to learn!

Thanks
Oli

--
Message posted via http://www.officekb.com