Hi

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

The separator used is determined by Regional Settings (Control
PanelRegional and Language OptionsNumbersDigit Grouping Symbol)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Excel learner" <Excel wrote in message
...
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