How to format say 123456789 in the format 12,34,56,789. This particular
number format is being used in India. (grouping of 2 digits rather than
3 excluding the last 3 digits)


--
harikrish
------------------------------------------------------------------------
harikrish's Profile: http://www.excelforum.com/member.php...o&userid=27100
View this thread: http://www.excelforum.com/showthread...hreadid=466476

What version of Excel.
In Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37)

If you just have positive numbers you can use as custom format like:

[=10000000]##\,##\,##\,##0.00; [=100000]##\,##\,##0.00;##,##0.00

see http://www.mvps.org/dmcritchie/excel...a.htm#bhattext

Negative and Positive Numbers can be handled with a subroutine or event macro by Norman Harker.
http://google.com/groups?threadm=e0n...GP11.phx .gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"harikrish" wrote in message
...

How to format say 123456789 in the format 12,34,56,789. This particular
number format is being used in India. (grouping of 2 digits rather than
3 excluding the last 3 digits)


--
harikrish
------------------------------------------------------------------------
harikrish's Profile: http://www.excelforum.com/member.php...o&userid=27100
View this thread: http://www.excelforum.com/showthread...hreadid=466476