LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add percentage to a cell Vicki_g New Users to Excel 8 May 14th 08 09:37 PM
exact percentage of each cell lea Excel Worksheet Functions 4 April 30th 08 06:47 PM
Can I add percentage to every cell in a column? Caitlin Excel Discussion (Misc queries) 2 April 28th 08 06:46 AM
Percentage of a cell geeka Excel Programming 4 April 6th 06 12:43 PM
How do I multiply cell value by percentage? Kelly P. Excel Worksheet Functions 4 October 27th 05 07:27 PM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"