How to add unit to cells in Excel - Excel Tips and Tricks

Learn how to add unit to a cell in Excel automatically.

Here are the steps for whole number.
1) Select a cell
2) Ctrl + 1
3) Number Tab --- Custom
4) Under "Type" text box, enter the following.
0 "pcs"
5) OK
6) Apply to all cells using Format Painter.


Here are the steps for decimal number (float/real).
1) Select a cell
2) Ctrl + 1
3) Number Tab --- Custom
4) Under "Type" text box, enter the following.
0.000 "kg"
5) OK
6) Apply to all cells using Format Painter.


how to add kg unit in excel,excel units in cell,how to add custom unit in excel,how to add units to excel graph,excel units of measure,how to add mm in excel,excel units conversion,how to add measurements in excel,