#### nlcrews

##### New Member
I am making a spreadsheet where I need to put a fraction in one cell and want the adjacent cell to automatically show the percentage. How do I do that? Thank you!

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### stanleydgromjr

##### Banned
nlcrews,

Welcome to the MrExcel board.

put a fraction in one cell and want the adjacent cell to automatically show the percentage

Can we have a few examples of the "fraction", and what the "percentage" should be for it?

Have a great day,
Stan

#### nlcrews

##### New Member
If I had a fraction of 13/17 the cell below would show 76% automatically. Also, how do I stop EXCEL from reducing fractions to the smaller numbers? Thanks so much!

#### stanleydgromjr

##### Banned
nlcrews,

I hope this helps.

Excel Workbook
AB
113/17Excel will interpret cell A1 as General format.
20.764705882If you start with the = sign to indicate a formula you will get 0.764705882 formatted as General.
376.47%Cell A3 contains the same formula as cell A2, but is formatted as Percentage with two decimal places.
Sheet1

Have a great day,
Stan

#### nlcrews

##### New Member
Thank you, I'll give this a try!

#### pahutchins

##### New Member
This is exactly what I need help on. However I don't want to type in the spreadsheet formula in A2. I want A2 to pull the fraction from A1 and compute it as a percentage. So when I update this spreadsheet annually, I only have to change the data in A1 and the percentage in A2 will automatically change. Any ideas?

Replies
1
Views
242
Replies
2
Views
207
Replies
3
Views
129
Replies
6
Views
321
Replies
1
Views
157

1,191,275
Messages
5,985,707
Members
439,975
Latest member
eelyn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back