Custom Format - Show 12.5 but not 12.0 (drop .0s) ?


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
 
Ad

Advertisements

J

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...
+ve;-ve;0
 
Ad

Advertisements

D

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

Top