How do I format a cell value to show kg?
Hi,
Format|Cells|Number
Select Custom
Enter 0.00"kg"
Mike
"Excel learner" wrote:
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
|