Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Batch Add Units to Cells in Excel Spreadsheet

Date:2019-8-29 Author:Cordelia

Adding units to one or several cells in Excel might not be difficult and many people are likely to type them after the values directly. However, this approach is not just time-consuming, but can also affect the result for calculation and invalidate some formulas. So, how to add units to multiple cells in Excel exactly? Format Cells can be a big help.

Case 1: Add Units

1. First, select the cells that you want to add units. Right-click the selected area and choose Format Cells… in the menu.

Or you can directly press [Ctrl+1] to evoke Format Cells.

How to Batch Add Units to Cells in Excel Spreadsheet

2. Select Custom as the Category in Number tab. Choose “0” in the list of Type (or enter it directly) which represents the values, and type the unit you want after it.

How to Batch Add Units to Cells in Excel Spreadsheet

3. After that, click OK to confirm the type and the units will be added to all selected cells in the document.

How to Batch Add Units to Cells in Excel Spreadsheet

Case 2: Add Decimal Places

1. If you want to add the decimal places to all these cells, similarly, you can open the Format Cells window at first.

2. Type the decimal point and the decimal digits according to your need. For example, you can input “.00” to add 2 decimal places to the selected cells.

How to Batch Add Units to Cells in Excel Spreadsheet

Case 3: Add Thousands Separator

1. If the numbers in your table are larger than 1000, you can add thousands separators to them with Format Cells.

2. Type “#,##” before “0” in the textbox and hit OK to confirm it. Then you’ll find the thousands separators have been added to your selected cells.

How to Batch Add Units to Cells in Excel Spreadsheet

In this way, you can customize any symbol and unit you want in Format Cells and add them to your data in batch.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *