Thread: Remove Decimals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyndi cyndi is offline
external usenet poster
 
Posts: 30
Default Remove Decimals

I have an excel sheet with data that is imported from another program, when I
veiw the info in the cell, that data has two decimals, which is fine, I then
need to copy and paste this into another excel workbook, and it shows up with
7 or more decimals, and I cant not remove them, format cells doesnt work,
decrease the decimal doesnt work, so I many have to retype each number, is
there a better way?
I use Excel 2003
Thanks