Learn how to add unit to a cell in Excel automatically.br br Here are the steps for whole number.br 1) Select a cellbr 2) Ctrl + 1br 3) Number Tab --- Custombr 4) Under "Type" text box, enter the following.br 0 "pcs"br 5) OKbr 6) Apply to all cells using Format Painter.br br br Here are the steps for decimal number (floatreal).br 1) Select a cellbr 2) Ctrl + 1br 3) Number Tab --- Custombr 4) Under "Type" text box, enter the following.br 0.000 "kg" br 5) OKbr 6) Apply to all cells using Format Painter.