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