Dear all,
Display Your Numbers As Thousands Sometimes you need display your numbers as thousands without changing the actual cell value. You can do that with a custom number format. Select the cells you want to format as thousands. In Excel 2003, click Format, Cells. In Excel 2007, click the dialog launcher arrow on the bottom right corner of the Number group. From the Number tab, click Custom, type 0, (zero comma) in the Type field and click OK. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
