Using Custom Format for Numbers, Dates and Text

Click here to read full article on 'Custom' Format.

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.

Let's move with some examples of various data. Essentially, examples makes this subject simple.
Leading Zeros 26 0026 0000
Phone Number 9999404843 999-940-4843 000-000-0000
Day of the Date 26/05/1984 Saturday dddd
Month of the Date 26/05/1984 May mmmm
Comma Place holder 23456789 23,456,789 #, ###
Currency 2605.5 € 2,605.50 € #,###.00

Click here to read full article on 'Custom' Format including intermediate and advanced examples with theory and logic.


Sparrow Services said...

Unknown said...

Do more like that very nice sharing more like that on

Roads Wilson said...


Great information,
Roads Wilson
chrome flash crash

Thanks for sharing

ajit said...
This comment has been removed by the author.
Unknown said...

Intersting and beautiful blog lovely presentation thanks for sharing your excel support We24support tech team are available 24/7 for repairs on computers, printers, laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and 1-866-978-0799 microsoft excel

Unknown said...

Intersting and beautiful blog lovely presentation thanks for sharing your excel support|Excel Support|microsoft excel 2010

Unknown said...

Get complete support for your computers, laptops, printers,network security, software errors etc by certified tech-experts of We24support immediately at toll free no 1 888 399 9656; active throughout 24/7/365 via remote assistance
we24support Software suppport