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

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
>

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