Good one. Hope the attachment meet your expectation.
Thanks and regards, Maidul On Wed, Jan 5, 2011 at 1:36 AM, OpenExcel.com <ashishj...@openexcel.com>wrote: > Hi Friends, > > *What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in > number formats, but in some cases they do not meet our needs, we can > customize a built-in number format to create our own. > > *Why 'Custom Format' and not 'Conditional Formatting'?:* because to cure > 'Common Cold' we go to doctors not surgeons. Exactly, when there is a simple > and robust way then why to go otherwise. There are many benefits of using > custom format including these: > 1. Less overhead than Conditional Formatting. > 2. Values can be used easily in formulas (Less manipulation required). > 3. Charts looks better with custom colored labels/axis. > 4. Works on all versions of Excel. > and many more which you can figure out using your innovative mind after > reading this article. > > Do you know how to use 'Custom' format in > Excel<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html>, > if yes then solve these 5 questions on 'Custom' format ... > > *COMMENTS * *TO DISPLAY* *AS * *USE WHICH CUSTOM FORMAT* Negative Number > -123000 (123K) ? Date 26/05/1984 Sat, May '84 Currency 6.56 £7 Labels 25 25" > feet" Round off to 1000000th 987654321 988 > If you don't know much about 'Custom' format then learn here. Hope you'll > enjoy it > :)<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> > > http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html > > > > ______________________________________ > Thanks & Regards > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > ______________________________________ > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Custom Format.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet