Excel Basics #13: Percentage Number Format

Dear Friends,

Best wishes!!!

In a pivot table a percentage column is added which calculates the percentage automatically. The percentage column shows the value with "%" (Ex. 54.12%). I tried different possibilities, but in vain.

How to avoid / re-format this to show only the value (i.e. I need only the value 54.12 - instead of 54.12%)

Thanks in advance,

acsishere.

Hello,

I've got some numbers on my excel spreadsheet and a cell to calculate the percentage.

For example, I've got cells called:
(C2) Target = 47
(C3) Achieved so far = 46
(C4) Percentage = 97.87%

I've formatted the percentage cell to 2 decimal places.

However, later on in the spreadsheet, I have a formula in C10 saying:

="Percentage of work achieved so far is " & C4

The cell returns "Percentage of work achieved so far is 0.978723404255319



How do I get it to just say 97.87%? Can I format the number within the formula? Or how can I get the string formula in C10 to return just the displayed contents from C4?

Thanks in advance!

I am using an autoshape as a progress bar in Excel 2007, and my macro effecectively resizes my rectangle from 0-100% based on the progress through my routine, and I added a line of code that actually writes the percantage into the Rectangles text field, but I can't figure out how to format the text string as a percentage...

Since I am using a variable to load text into the box, without formatting its showing up like this: 6.213545312 when I am at that percentage progress..

I would like it to show up as 6.21%

Is this possible??

Hi! I have a graph which displays the movement of a parameter in percentages.

On the y-axis are the percentages displayed, e.g. 5,0%

I want to show these numbers on this axis without the '%'-sign, so e.g. 5,0

Which custom format should/can I use? I'm using Excel 2007.

I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.

Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help



How do you format a cell to have dollar signs next to the numbers?



How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A



How do you add up all the contents of column D and make the answer show
up in column C?


Thanks in advance!
abi

I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

I have been working in a worksheet with 10 tabs, and suddenly all of my numbers turned to long date format. I manually changed them all back to what they were. General, Currency, %, etc. but the default seems to be stuck in the long date format. When I create a new tab it is automatically all long dates. Very strange.
Oh, and the other weird thing is when I send it to other people, some people see the correct formats and when other's open it the numbers all go back to the long date format. VERY Frustrating.
Would love to get some advice.

So right now my VBA code Concatenates numbers from a variable into a cell to look like

x / y / z

However, x y and z do not match the number formats I want, as they'll say 5 or 6.1... I want it to display 2 decimal places.. how do I alter this in my VBA code with respect to the variable that is used to "insert" these concatenations? It concatenates to the end every time if that matters.

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!