Is there a way of excel automatically recognising how many decimal places I need. Ideally so that any figure which is less than say 20 displays 1 decimal place any figure less than 2 displays 2 decimal places and anything above 20 displays 0 decimal places.
Would make my life alot easier
Cheers
Would make my life alot easier
Cheers