Excel 2007 : Units behind of formula

[ALEZI]

Hi guys,

Maybe i have sample question for you,but how we have put units behind of the some formulas for example,SUM( B3:B4)in Kg.

[martindwilson]

format cell as custom #,##0.00 "kg"; -#,##0.00 "kg"; 0.00 "kg"
or simply add it to the end as text
SUM( B3:B4)&" kg"
the first way you can do things with the result as a number , the second way makes the result a text string and calculations cant be done with it