Here is an answer from Bob Phillips to a similar request
================================================== ====
Hi Rajiv,

I think you may be intrested in the add-in I have modified for the

Indian numbering/currency system. The original code is available on MS

site for English system. The add-in is attached in zipped format. If

you need any help, do let me know.



Regards,



+-------------------------------------------------------------------+

|Filename: KVM Numbers in Words or Rupees.zip |

|Download: http://www.excelforum.com/attachment.php?postid=3484 |

+-------------------------------------------------------------------+

================================================== ====


--
Kind regards,

Niek Otten

Microsoft MVP - Excel



"hsg" wrote in message
...
normal format for number & currency in excel is
xxx,xxx,xxx,xxx.00

How to configure numbers as well as currency as

xx,xx,xx,xx,xx,xx,xx,xx,xxx.00 format ?

when custom format is used, the entry is converted to
thousand comma separator format.

pl help