How to add units to cells in Excel

Each item, represented data in Excel, will have formats for specific symbols such as Excel currency symbols, date format, time or percent format. Each type of unit format will be separated into each item in Format Cells for users to choose to use. However, while processing data tables, format units are not always available for you to apply immediately to the data sheet.

There are many types of non-supported Excel units that users have to manually add units to use. Even in Format Cells, a separate item is available so that we can enter new units that we want to add to the data used in the Excel table. The following article will guide you how to add units to cells in Excel.

1. How to adjust the date and currency format in Google Sheets
2. MS Excel 2003 - Lesson 2: Format spreadsheet data
3. Guide to full Excel 2016 (Part 8): Learn about Number Formats
4. How to convert commas into dots in Excel

Instructions for adding cell units in Excel

We will deal with the data table below. The unit to be used is a pair of columns for shoes and sets for columns of Clothes. These 2 units are not available in Excel but you must manually add them.

How to add units to cells in Excel Picture 1

Step 1:

First, you need to highlight the column to add the unit, then right-click and choose Format Cells .

How to add units to cells in Excel Picture 2

Step 2:

Displays the format editing interface for cells in Excel. Here we click on the Custom group to customize the unit for the cell in Excel. Then click on 0 to display it as in Type.

How to add units to cells in Excel Picture 3

Step 3:

Next in the Type section we type the new unit we want to add to the cell in Excel, such as 0 'double' . Spaces and diacritics are required in the unit you want to add. Click Ok below to add.

How to add units to cells in Excel Picture 4

The result of that column has been added as shown below.

How to add units to cells in Excel Picture 5

Next we have to add a new unit for the other column with the same way.

How to add units to cells in Excel Picture 6

Users can also add units to the first cell as shown above, then click the Format Painter icon to copy the units for all the remaining cells in the data column.

How to add units to cells in Excel Picture 7

Then the unit is also applied to the entire cell in the column.

How to add units to cells in Excel Picture 8

With this method, you will easily add new units to represent data in Excel cells when not available. While entering a new unit in Format Cells we need to enter the correct syntax to display the unit for the cell.

I wish you all success!