How do I format a cell value to show kg?

  • Thread starter Thread starter Excel learner
  • Start date Start date
E

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
 
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)
 
Back
Top