How do you convert percentage to numbers?

[ExcelUser08]

I have a question on formats. Here is what I am trying to do. For example, sales for this year is 5.8% vs. last year 4.6%. I need to capture the change. For example the difference in the change will be 5.80% - 4.60% = 1.20%, which is 120 basis points. When I do this in excel, I need to show 120 instead of 1.20%...can someone help me on the format? Is there a formula where I can used to achieve this? Thanks!!

 

[Kaps_mr2]

just multiply by 100 and then format as number - with your chosen number of decimal places.

 

[Peter_SSs]

I think you will actually have to multiply by 10,000. Formula in C2 is copied down.

Excel Workbook
	A	B	C
1	Last Year	Last Year	Basis Points Change
2	5.80%	4.60%	120
3	6.10%	6.05%	5
4	5%	6%	-100
Basis Points Diff

 

[Kaps_mr2]

indeed Peter is correct !!!

 

[Peter_SSs]

indeed Peter is correct !!!

It is always a good idea to test your suggestions!

 

[mikerickson]

If .012 is the underlying value, formatting to percentage will display 1.2%.
If you use the custom format 0 %% the cell will display 120 %%, leaving the underlying value unchanged.