Number Format

[harikrish]

How to format say 123456789 in the format 12,34,56,789. This particula
number format is being used in India. (grouping of 2 digits rather tha
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/formula.htm#bhattext

Negative and Positive Numbers can be handled with a subroutine or event macro by Norman Harker.
http://google.com/[email protected]