| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format <10, show 1 decimal....
On Mon, 5 May 2008 08:44:03 -0700, jazzii
wrote: Hi, thanks for the info. I will need the forth condition as well, i.e. if -10.1, show as 10 in Red. However, I do not know VBA. If there is another other method, please share thanks!! You could use a formula to round numbers appropriately, and then format to RED or not depending on if the result is ABS(10). Do you have formulas in the cells? If not, you will have to separate your data entry from your display. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
