Custom Number Formatting in Excel

(Must Watch) Custom Number Formatting Tips & Tricks: Adding Country Code Automatically in Excel:- This video show you how to add leading zeros, insert your country code or area code automatically when you enter mobile or telephone number. You can separate Pin ID and enter amount with country name and currency symbol. You can create your own date and time format.

Applying custom numbers/texts format on cells or range, you can create your own number format. Excel provides several built-in formats. You can convert General format into Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and modify with your choice.