I was wondering if there is any way in Excel 2003 to limit a cell to only showing 1 decimal place IF there is anything after the decimal, but if there is not, to show nothing instead of the .0 it places after all values if I format to be a number cell with 1 decimal place.