View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark evans mark evans is offline
external usenet poster
 
Posts: 1
Default Percentage in a cell


Hi

I am having a problem with a spreadsheet.

Basically i have 4 cells each having numbers in it. What i want is for
each cell to show a percentage and not a number.

Ie. Cell 1 Cell 2 Cell 3 Cell 4

17 17 17 17

Rather than showing 17 points in each cell it should show 25%.

It is a sports spreadsheet where each cell in a each round will score
3,2,1 or 0.

so after the first round it could look like

cell 1 cell 2 cell 3 cell 4

2 3 1 0


but i would like the 2,3,1,0 to show as %

Thanks


--
mark evans
------------------------------------------------------------------------
mark evans's Profile: http://www.excelforum.com/member.php...o&userid=35760
View this thread: http://www.excelforum.com/showthread...hreadid=555358