Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format - Show 12.5 but not 12.0 (drop .0s) ?
I'm scratching my head and trying lots of different things here.....
I've created a Drop-down list that contains both whole numbers and numbers with 1 decimal place (this is always .5 eg 1.5, 2.5, 7.5 & 12.5). How can I custom format the cells with these drop-downs to show the .5 whenever it is present but NOT show the whole numbers as eg 10.0 (just show it as 10) ? (I've tried them as Text & General but these both round Up the 12.5 to 13 - not what I want). These drop-dows go towards a TOTAL at the end of each row so I can't enter them as text. Oddly enough, the TOTAL column is formated as General and this displays it as I want it to (shows xx.5 and xx).......I can't figure that one out. Basically what I'm asking is, Is it possible to format these cells to 1 decimal place & no decimal place depending on the number chosen from the list. If anyone could also explain to me the syntax meanings in Custom Format of # ; 0 (what do they each do or mean) ? (It might save me from having to ask questions about it in the future). Thanks in Advace for any help on either of these questions John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format - Show 12.5 but not 12.0 (drop .0s) ?
Format it to General to display as 12.5 as 12.5 and 12 as 12
# is digit placeholder which do not display extra zeros 0 is digit placeholder which pads the value with zeros to fill the format. ; is the separator used in custom formats to differentiate positive section, negative section and zeroes as below... +ve;-ve;0 -- Jacob "Originalgoth" wrote: I'm scratching my head and trying lots of different things here..... I've created a Drop-down list that contains both whole numbers and numbers with 1 decimal place (this is always .5 eg 1.5, 2.5, 7.5 & 12.5). How can I custom format the cells with these drop-downs to show the .5 whenever it is present but NOT show the whole numbers as eg 10.0 (just show it as 10) ? (I've tried them as Text & General but these both round Up the 12.5 to 13 - not what I want). These drop-dows go towards a TOTAL at the end of each row so I can't enter them as text. Oddly enough, the TOTAL column is formated as General and this displays it as I want it to (shows xx.5 and xx).......I can't figure that one out. Basically what I'm asking is, Is it possible to format these cells to 1 decimal place & no decimal place depending on the number chosen from the list. If anyone could also explain to me the syntax meanings in Custom Format of # ; 0 (what do they each do or mean) ? (It might save me from having to ask questions about it in the future). Thanks in Advace for any help on either of these questions John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format - Show 12.5 but not 12.0 (drop .0s) ?
Did you try using a General format and widening the column or reducing the font
size--like in your earlier post Originalgoth wrote: I'm scratching my head and trying lots of different things here..... I've created a Drop-down list that contains both whole numbers and numbers with 1 decimal place (this is always .5 eg 1.5, 2.5, 7.5 & 12.5). How can I custom format the cells with these drop-downs to show the .5 whenever it is present but NOT show the whole numbers as eg 10.0 (just show it as 10) ? (I've tried them as Text & General but these both round Up the 12.5 to 13 - not what I want). These drop-dows go towards a TOTAL at the end of each row so I can't enter them as text. Oddly enough, the TOTAL column is formated as General and this displays it as I want it to (shows xx.5 and xx).......I can't figure that one out. Basically what I'm asking is, Is it possible to format these cells to 1 decimal place & no decimal place depending on the number chosen from the list. If anyone could also explain to me the syntax meanings in Custom Format of # ; 0 (what do they each do or mean) ? (It might save me from having to ask questions about it in the future). Thanks in Advace for any help on either of these questions John -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format show < +/-500 as zero not blank | Excel Worksheet Functions | |||
How do I custom format $11 to show $11,000,000? | Excel Discussion (Misc queries) | |||
I need a custom format of this number 70226 to show it 02/26/07. | Excel Worksheet Functions | |||
Custom Format - show as decimal | Excel Discussion (Misc queries) | |||
how do I custom format .0040 to show as 40 ? | Excel Discussion (Misc queries) |