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.comwrote:
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
Excelhttp://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 100th 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=wallref=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=wallref=ts
Custom Format.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet