Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Converting Kilos to Stones | Excel Worksheet Functions | |||
How do I enter a SSN but only display the last four digits? | Excel Discussion (Misc queries) | |||
how do I enter a value, display that many fields? | Excel Discussion (Misc queries) | |||
does anyone have a chart for weight gain or loss in kilos? | Excel Discussion (Misc queries) | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |