If i've got a column of values where some include pennies and some are just whole pounds, is there a way that i can format the column so that whole pounds show to no decimal places but the lines with pennies still show to two decimals? I know i could do it with an IF statement but i wondered if...