Type 100 in an empty cell.

Copy that cell.

Select the range to change and paste specialmultiplyokesc

Clear the cell with 100


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 10:46:21 -0700, AAA1986
wrote:

I have a column that is listed in decimals: e.g. .15, .30, .45. I would like
the column to be changed to whole numbers: 15, 30, 45. I was only able to
convert these to percentages, 15% etc., but not to whole numbers.

Thanks.