fraction in excel

Dorothychin

Board Regular
Joined
Oct 7, 2002
Messages
130
Hi

I'd like to input fraction into excel spreedsheet, like the format given in the character map. I have tried format cell -> fraction but this is not what I want.

Does anyone has a suggestion?
Thanks!
Dorothy
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,257
Are you only looking to enter the ¾ (ascii #190) character ? If so, try:

=CHAR(190)
Or
Alt+0190

If you are trying to format numbers and text in a cell that involves the ¾ character then please repost with specifics.
 

Dorothychin

Board Regular
Joined
Oct 7, 2002
Messages
130

ADVERTISEMENT

let's say i want to convert 1/16 into a fraction font which looks something like ¾, how to do that?

Thanks
Dorothy
 

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890

ADVERTISEMENT

Dorothy,

I'm using ASAP utilities to launch the character map. Just click on 3/4 on the map, select and copy, then click on a cell and paste
 

Dorothychin

Board Regular
Joined
Oct 7, 2002
Messages
130
odd fraction like 1/16, 5/32, etc is not available in the char map.

pls help.

Dorothy
 

Haluk

Rules Violation
Joined
Oct 26, 2002
Messages
1,075
Hi;

i don't know if this helps but, you may try something like this;

assume you've entered 5 1/16 in cell A1. Format the cell as " Text". After selecting the cell A1, enter to the formula bar and select 1/16 with the mouse. Then, from the menu bar; Format | Cells >>Font, check "Superscript"
 

Forum statistics

Threads
1,143,615
Messages
5,719,721
Members
422,242
Latest member
hishamkhatri

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top