View Single Post
  #1   Report Post  
Ragdyer
 
Posts: n/a
Default

Try custom format:

[<=5]###.0;[5]###;General

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"K M" <K wrote in message
...
If the numeric value in the cell is less than or equal to 5 I would like

the
number to be displayed with one decimal value. If in the same cell the

value
is 5 I would like the number to be displayed with 0 decimal places. The

cell
I am talking about is itself composed of ROUND function.

How can this be done?