Dear Harsh,
Right-click on the cells which you want to display as lakhs, and click on *Format Cells**, *then go to the *Custom *category and enter the below formats: For Lakhs (+ve and -ve): With 2 decimals: [>99999]##\,##\,##0.00;[<-99999.99]-##\,##\,##0.00;##,##0.00 Without decimals: [>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0 For Lakhs and crores (+ve) [>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00 For Lakhs and crores (-ve) [<-9999999](##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00 There is an easier way to change the global settings from Settings > Control Panel > Regional Settings > Numbers, but that will affect all your Excel sheets and the change will be visible only on your system and not on your files which you send to others. Reference of the above taken from : http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/ Regards, Andy On Wed, May 27, 2009 at 3:47 PM, harsh shah <harshsha...@gmail.com> wrote: > hello > > i want currency to be shown in terms of lacs & crores instead of millions. > > can anyone provide help on comma presentation ? > > any add in for that ? > > -harsh. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
