O
Originalgoth
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
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