View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
automatic units dispfor a number entered automatic units dispfor a number entered is offline
external usenet poster
 
Posts: 1
Default enter 45, display 45 kilos

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.