Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting question
Hi again,
After long time w/o practice, please help me to use format in a column of data i.e. formatcellnumber.... 21 21.1 21.15 21.154 21.1546 I need to show all the decimals w/o showing the tailing "0's" if possible with a combined conditional color effect if the cell contain number decimal numbers exceeds to 2 places. (i.e. 21.154, 21.1546, etc) anything possible is appreciated in advance. -- regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting question | Excel Worksheet Functions | |||
Formatting question | New Users to Excel | |||
Formatting Question | Excel Discussion (Misc queries) | |||
Formatting Question | Excel Discussion (Misc queries) | |||
Formatting Question | Excel Worksheet Functions |