Showing a fraction in the "normal " form

[JohnJW]

I've only just found out in Microsoft Word how to type a fraction in the "normal" way, that is with the digits one above the other - if .5 is wanted as a fraction, type 1 followed by / followed by 2. Then press the space bar. The 1/2 changes to 1 over 2.(can't show it here!) I have been looking for something similar in Excel, but have had no luck. Is it possible? Showing 1.5 as 1 1/2, with all digits on the same line can be a little confusing.

regards John W

 

[Fluff]

Assuming you want something like ½ then, not really.

 

[mumps]

Have you tried exploring the Equation Editor in Excel? I'm not sure if it would meet your needs but it will allow you to write fractions with the numerator above the denominator separated by a horizontal line in the traditional sense.

 

[JohnJW]

Disappointing response. I was hoping I'd missed something. Thank you anyway for prompt reply.

regards, John W

 

[JohnJW]

Just seen your post. Not tried your suggestion yet, but will do. I'll let you know how I get on

regards John W

 

[Fluff]

I was hoping I'd missed something.

Unfortunately not, you can use the Equation editor, as mentioned by mumps, but that inserts an image object, or you can use specialist fonts, but that is treated as text.

 

[Leith Ross]

Hello JohnJW,

You can format the cells as fractions using the Format Cells... context menu and then selecting the Numbers tab. Under Category, select Fraction. On the right side you will see several different formats to select from. Once the cell is formatted, entering a number like 1.5 will be converted into 1 1/2.

 

[shg]

I think he's looking to enter formulas with character codes 188/189/190, e.g.,

=A1+½

 

[JohnJW]

Thank you, Mumps. Leith Ross has suggested something similar. In both cases I can change a decimal number to a fraction, but the fraction digits are still on the same line - not in the traditional form which I was hoping for. I am running Windows 10, which includes Microsoft Office 2007 - maybe a different version of Office is required.
Thank you all for your attention
Regards, John W

 

[shg]

The answer is no, you cannot, in any version of Excel.