Thought I'd ask here with the assumption there are Excel experts here! If I have '6.35' in a cell I can use 'format cell' and change the decimal place to nothing to show '6'. What I want is to show '6' even if the number is '6.78'. Anyone?

If you use format cell, the actual number stored in the cell doesn't change - only the way it is displayed. Hence if you use that cell in a calculation, Excel will use the real number, not the displayed number. If you want to actually round the number so the number stored is just an integer (no decimal places), use either ROUND, ROUNDUP or ROUNDDOWN functions with num_digits set to 0. Alternatively the INT function rounds a number down to the nearest integer. Note that ROUNDDOWN and INT behave slightly differently for negative numbers.