How do I format a cell value to show kg?

[Excel learner]

Please could someone help me with this?

I would like to use Kilogrammes (kg) but can not find it in the "format
cells". What I do is to type in "12345.67" and for the cell to show /
recognise it as "12,345.67kg".

So if I do any calcualtions or type in figures the cell will always show
"kg" as a suffix and use " , " as a separtor.

Thank you

 

[Mike H]

Hi,

Format|Cells|Number
Select Custom
Enter 0.00"kg"

Mike

 

[Arvi Laanemets]

Hi

Format cells as Custom "# ##0.00_ kg".

The separator used is determined by Regional Settings (Control
Panel>Regional and Language Options>Numbers>Digit Grouping Symbol)