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




Jacob Skaria

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...



Dave Peterson

Did you try using a General format and widening the column or reducing the font
size--like in your earlier post

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question