In excel 2003 format like 12,34,567

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hirendra7158 - 18 Nov 2007 04:22 GMT

how do i format currency to display 12,34,56,789.00 instead of 123,456,789.00
Please mark placing of Thousand separator .

I have Regional and Language Options set up in my way, but excel still does
not return my way. I have checked "use system seperator" on.
thanks,

Reply to this Message

Niek Otten - 18 Nov 2007 09:52 GMT

From the newsgroup archives, this answer from Bernard Liengme:

Format Custom as

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| how do i format currency to display 12,34,56,789.00 instead of 123,456,789.00
| Please mark placing of Thousand separator .
|
| I have Regional and Language Options set up in my way, but excel still does
| not return my way. I have checked "use system seperator" on.
| thanks,

Reply to this Message

hirendra7158 - 24 Nov 2007 13:35 GMT

Thanks Mr. Niek, I have not yet tried your solution, but looking at and
trying to understand the logic, I am pretty sure that this solution should
work. Thanks again.

> From the newsgroup archives, this answer from Bernard Liengme:
>
[quoted text clipped - 8 lines]
> | not return my way. I have checked "use system seperator" on.
> | thanks,

Reply to this Message

Shah Shailesh - 18 Nov 2007 10:20 GMT

Besides you can download one free addins "Indian Rupees" from below site to
convert the number format to Indian system & convert number to Indian Rupees
in words.

http://in.geocities.com/shahshaileshs/

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins

> how do i format currency to display 12,34,56,789.00 instead of
> 123,456,789.00
[quoted text clipped - 4 lines]
> not return my way. I have checked "use system seperator" on.
> thanks,

Reply to this Message