In excel 2003 format like 12,34,567

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
From the newsgroup archives, this answer from Bernard Liengme:

Format Custom as

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

--
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,
 
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.
 
Back
Top