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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting question
#,##0.#####
although this shows 21 as 21. -- __________________________________ HTH Bob "driller" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting question
How about "General"?
"driller" wrote in message ... 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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting question
thanks Bobs,
21 21.1 21.15 21.154 21.1546 My bad, I have not shown the purpose very clearly . Actually, format "#,##0.####" fits well even with "." shown after 21. Yet, I need to present the visual result showing the numbers with excessive decimals. Is it possible to have all these <column numbers be shown with all the "." <periods be aligned vertically ? In this case, I may not need to use the conditional format. -- regards |
Reply |
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 |