formula for decimal point

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

I have a cell formatted to show 2 decimal points as 9.50.
If the figure is a whole number only as in 9
Is it possible to format so it doesnt show 9.00

This number is variable but would like if possible not to show the 2
decimal places on whole numbers.
 
Hi,

Am Tue, 03 Feb 2015 17:10:21 +0000 schrieb ss:
I have a cell formatted to show 2 decimal points as 9.50.
If the figure is a whole number only as in 9
Is it possible to format so it doesnt show 9.00
Click to expand...

your numbers in column A. Select the column and format the cells as
decimal. Then Conditional Formatting => New Rule => Formula to determine
=> =MOD(A1,1)=0 => Format => Numbers => General


Regards
Claus B.
 
=> =MOD(A1,1)=0 => Format => Numbers => General
Click to expand...


I have set the cell to 2 decimal points under number

and this is what appears in the rule description:
="""> =MOD(A1,1)=0 => Format => Numbers => General"""

It doesnt appear to change the 9.00 to 9

Have I copy/pasted your formula correctly?
 
Back
Top