antowan Honorary Master Joined Nov 1, 2003 Messages 13,172 Reaction score 299 Location Unknown Aug 4, 2008 #1 How can you make ".20" show up as "20" in excel?
B bekdik Honorary Master Joined Dec 5, 2004 Messages 12,860 Reaction score 20 Location I exist only in my own mind ... Aug 4, 2008 #2 format the cell as %
H HavocXphere Honorary Master Joined Oct 19, 2007 Messages 33,153 Reaction score 1,297 Location Europe Aug 4, 2008 #3 Multiple by 100 or use the number formatting...depends on what you want to achieve.