Make a cell show units

[abrunstad]

Hello,

I want to make a specific cell show the unit "KG", in adition to the value.
I cannot type in the "KG" manually, because then exel cannot us the value in a forumla (Yo will gett error).

I do not want to show the unit in the cell next to it.


EX; CELL A1: shows; 3000 KG
.......CELL A2: shows; 3000 KG

CELL A3: =(A1 + A2) shows 6000

[shg]

Format the cells as General"Kg", or 0.0"Kg", or any other number format followed by "Kg"