i want to trim the values in a excel sheet as a whole
C Corey Jun 23, 2006 #2 Right Click the Cell and, Format Cells - Number - Take the Decimal places away. This will round to next whole number. Corey....
Right Click the Cell and, Format Cells - Number - Take the Decimal places away. This will round to next whole number. Corey....
N Norman Jones Jun 23, 2006 #3 Hi Corey, See David McRitchie's TrimAll page at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Hi Corey, See David McRitchie's TrimAll page at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall
