Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to format a number if <10, to show 1 decimal place, if =10, no
decimal place and with red colour for negative numbers. e.g. 1.24 to show as 1.2 (numbers in black) 10.6 to show as 11 (numbers in black) -2.63 to show as 2.6 (numbers should be in red to denote negative) I am trying to avoid using functions in the cells itself. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Show decimal as percent | Excel Discussion (Misc queries) | |||
conditional format of number? -- show decimal ONLY IF not 0 | Excel Discussion (Misc queries) | |||
Custom Format - show as decimal | Excel Discussion (Misc queries) | |||
How Show decimal in Bar Function | Excel Worksheet Functions |