Question about Microsoft Corporation Microsoft EXCEL 97 Spreadsheet Program for Windows

1 Answer

How do I fix how my percentage shows on the excel spreadsheet?

Posted by Anonymous on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 29 Answers

On the home toolbar, there is a section titled "Number". That would be where you would change the format to whatever you want it to. Even Red..
So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..

Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.

Posted on Apr 08, 2015

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I calculated percentage on excel using a formula but still it shows #value?. what do i have do to fix this? please help.


Right Click on cell with mouse and select format cells
then select number . If formula was for example percentage of cell a2 calculated from b2 calculated in c2 then in c2 you put =a2/b2
Then you can use percentage in the number format
or you can go =(a2/b2)*100
Also make the cell width more if a problem.
https://www.youtube.com/watch?v=UlD6vUKx2KE

Apr 08, 2017 | Excel Computers & Internet

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

1 Answer

How to open excel sheet in different window?


While one spreadsheet is open in Excel, open the second spreadsheet as follows:

Go to Start, Programs, Excel (or however you navigate to Excel). Then in the new Excel window select FILE, OPEN, then your 2nd spreadsheet.

Mar 29, 2011 | Microsoft Windows XP Professional

1 Answer

Prints out of alignment on excel spreadsheets


go to print preview, then to the margins button at the top and click it, margins will appear on the page, adjust your margins to the edges of the page, if the spreadsheet is supposed to be on one page and doesnt fit, go to page setup and shrink the size of the document (will be percentage), either way--once you have moved your margins out to the edges, you can then move them back in a little at a time if you need to in order to center your document on the page. Hope this helped.

May 10, 2010 | HP LaserJet 1320 Printer

1 Answer

How to add % (Percentage column ) in the excel


The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

1 Answer

Percentage formula


=(Click cell that you want to work out 30% of)*30/100

Nov 30, 2008 | Microsoft Excel for PC

1 Answer

Excel spreadsheet is protected. I do not remember the password. how can i get in?


lok on google for password cracker for excel download and it will open any locked spreadsheet

Oct 14, 2008 | Microsoft Office Standard for PC

1 Answer

Percentages in Excel


No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Corporation Microsoft EXCEL 97 Spreadsheet Program for Windows Logo

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Corporation Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Microsoft Corporation Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...