Since I exclusively use Open Office, I had very little hope that this would work for me but it does without a hitch! I was able to create a number format that shows up as 12,34,56,789.00 instead of the western 123,456,789.00. The trick is to use a conditional format. On my system I’ve called it Indian Currency although I understand it’s also used in Thailand:

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

Go to: David McRitchie’s Excel Pages :: Scroll down to format #37

If you’re an Excel user, you might want to look at this add-in which has additional features.

• 2004.07.17 : A9 Cad
• 2007.12.04 : Additional Lightworks Material Libraries
• 2008.03.11 : Download GDL Cookbook 4 [PDF]
• 2006.09.11 : Site Overhaul
• 2007.06.23 : Everlasting Bulb
• 2007.12.09 : COR Furniture Library