Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
In excel 2003 format like 12,34,567
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, |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
In excel 2003 format like 12,34,567
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 "hirendra7158" wrote in message ... | 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, |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
In excel 2003 format like 12,34,567
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 "hirendra7158" wrote in message ... 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, |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
In excel 2003 format like 12,34,567
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. "Niek Otten" wrote: 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 "hirendra7158" wrote in message ... | 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 2007 format (*.xlsx) into Excel 2003 format | Excel Discussion (Misc queries) | |||
% format in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Format | Excel Worksheet Functions | |||
date format in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 date format bug? | Excel Discussion (Misc queries) |