(custom format) If number is INTEGER, don't show decimals, but...

[roc_on_the_rocks]

How to CUSTOM FORMAT a cell... if number is INTEGER, don't show decimals (e.g.: 24), but if fractional, show first decimal point (e.g.: 24.5)?

Following this example, I don't want to have '24.0', but '24' instead.

I appreciate the help!

 

[shg]

I think the closest you'll get is to custom format as 0.# which will always show the decimal point, but not a non-zero decimal

 

[Marcelo Branco]

This is not beautiful but i think it works

Assuming formatting A1

1. First format A1 as Number with 1 decimal place

2. Go to Conditional Formatting
New Rule
Use a formula to.. (the last option)

and insert this formula
=SEARCH(".0",TEXT(A1,"0.0"))

Click the Format button
and pick Number with 0 decimal places

Ok, Ok

done

Now you can use the Format Painter to apply the format to other cells.

HTH

M.

 

[roc_on_the_rocks]

Marcelo, this is very ingenious, it works great! This trick is a keeper. Muito obrigado!

shg4421, thanks too, you got me closer.

 

[Marcelo Branco]

Roc,

Thanks very much for your kind words.
(and specially for the "Muito Obrigado" )

All the best

M.