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.

enter 45, display 45 kilos
 

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.

enter 45, display 45 kilos
 

Simply custom format cells: Right Click cellFormat CellsCustom and
type 0"Kilos", if you do not use the quotes then it will only accept
Kilo.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58703

enter 45, display 45 kilos
 

Custom format of #,##0.00" kilos"


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 11:44:04 -0800, automatic units dispfor a number entered
<automatic units dispfor a number 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.