View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T T is offline
external usenet poster
 
Posts: 41
Default Decimal/Percentage to Whole Number

right clikc on the cell with the decimal and go down to where it says format
cell. click on number and it will ask how many decimals u want after. or u
can do it as text-do it this way if some of you numbers start with 0. in
number format the 0 will not show up

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