Number Format:How to format say 123456789 in the format 12,34,56,789

[harikrish]

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)

[David McRitchie]

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...TNGP11.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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>