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

you need to right click on that cell and go down to where it sauys format
cell. format it as a number and it should give you whole numbers if that
doesnt work try formating it as a text

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