On 10/27/07, Jayant Gedam <[EMAIL PROTECTED]> wrote: > > I want to format comma separator like this in spredsheet: > 1,00,00,00,000.00 > (This is Indian pattern of displaying numbers and currencies)
This format code works, sort of. [>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0 Numbers from 0 to 100 million are displayed correctly. There are some limitations though, no decimal display and using the add or remove decimal tool bar button removes the Indian formating. To add decimals, you have to have a different format code for each number of decimal formats you want to display. This format is for two decimals. [>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00 I haven't found a way to properly format numbers beyond 100 million. The code for numbers to 100 million was found here... http://help.lockergnome.com/office/set-numbers-Indian-Style-ftopict565238.htmlin Gordon's post of July 5th, 2005. I confirmed how to add decimals and identified the 100 million limit. I don't know Calc very well but it seems to me that if regular expressions can be used in format codes there might be a way to build the format code so it understands there needs to be a repeating pattern of 00, for numbers greater than 99,999. e.g. 1,00,000; 1,00,00,000; etc.
