enter 45, display 45 kilos

[automatic units dispfor a number entered]

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.

 

[Mike H]

Hi

A custom format of

##.00 "Kilos"

and follow the same format for others

Mike

 

[Gord Dibben]

Custom format of #,##0.00" kilos"


Gord Dibben MS Excel MVP