Custom Excel Number Format

MS Excel is a very important tool for businesses as well as for individuals with very useful features and tools. It is a market leader in spreadsheet editing and managing software. MS Excel contains many inbuilt number formats that can be used as per the needs of the user, however, sometimes users may need specific custom number formats that are not available in Excel by default.

For example, if we want to round a decimal number to one digit after the decimal point, if we consider the number 44.64  we can use the custom number format ##.# to convert it to 44.6. If you want to represent number 347523450 using the Indian number system, of crores, lakhs, and thousands you can use the custom number format ##\,##\,##\,### to convert it to 34,75,23,450. First, let’s consider the list of the following numbers given below :

To Convert these numbers into our required format we have to execute the following steps:

Step 1: Drag and select the numbers whose format has to be changed using the cursor.

Step 2: a) Go to home and click on format.

b) Then click on Format Cells.

Or

a) Right-Click and choose Format Cells.

Format Cells Dialog Box appears.

Step 3: Choose a custom option from the given Dialog Box.

Step 4: Double-Click on the Type box and erase the given format and type your required format as shown and press ok to convert the given number into your required format.

Step 5: The numbers change to the required format.

This is the way in which numbers can be changed to any custom format. However, if you would want to remove the custom formatting from your numbers you can follow the given steps:

Step 1: Follow Step 1, Step 2, and Step 3 mentioned above in the article to go to Format Cells, Custom Format Tab as shown below:

Step 2: Erase the format present in the custom dialog box and keep it blank and click on ok.

Step 3: The number format changes to the original.