Hi

A custom format of

##.00 "Kilos"

and follow the same format for others

Mike
"automatic units dispfor a number entered" wrote:

How to format a cell so that it will display a number entered with the units
desired. eg. if you enter 345, it will display 345 days, kilos, miles etc.