There might be a way to do this via custom formatting but a fairly quick way
to do ith otherwise would be to insert a column next to the one with the
decimals and then put a formula like this in and then copy down.

=A1*100

A1 being the 1st cell where your decimal data starts. After doing that you
could copy all of those results and 'paste special' ... 'values' right over
top of them. (thus giving you whole numbers rather than the formulas.)

"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.