Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pecentage
I am working on a spreadsheet and I am trying to divide cell a1 (100,000) by
e5 (3,500) I got 28.57, but I want to change this to a percentage. When I click on the percentage symbol I keep getting 2857%. I tried adjusting the decimal places, and this doesn't work. I'm working in Excel 2007. Can someone please help me? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pecentage
Hi
As a percentage, that is the correct answer, well 2857.14% to be precise to 2 decimal places. I usually format the cells first with the percentage and number of decimal places I want, then enter the calculation -- Regards Roger Govier "Té" wrote in message ... I am working on a spreadsheet and I am trying to divide cell a1 (100,000) by e5 (3,500) I got 28.57, but I want to change this to a percentage. When I click on the percentage symbol I keep getting 2857%. I tried adjusting the decimal places, and this doesn't work. I'm working in Excel 2007. Can someone please help me? Thank you. __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the Body Fat Pecentage to work on fitness template | Excel Discussion (Misc queries) |