ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fractions (https://www.excelbanter.com/excel-discussion-misc-queries/217602-fractions.html)

Tia

Fractions
 
I'm trying to enter 1 3/4 Gallon Kit into a cell, but I want the 3/4 to show
up smaller than the 1. Is there any way to do this?

Thanks,
Tia

Bob I

Fractions
 
Insert, Symbol, Cambria Math font has one.

Tia wrote:

I'm trying to enter 1 3/4 Gallon Kit into a cell, but I want the 3/4 to show
up smaller than the 1. Is there any way to do this?

Thanks,
Tia



Pete_UK

Fractions
 
To get the ¾ symbol, you need to hold down the Alt key and type 0190
on the numeric keypad at the same time. That way you can get:

1¾ Gallon Kit

in the cell (you probably don't need the space that separates 1 3/4 in
your example.

Hope this helps.

Pete

On Jan 23, 2:51*pm, Tia wrote:
I'm trying to enter 1 3/4 Gallon Kit into a cell, but I want the 3/4 to show
up smaller than the 1. *Is there any way to do this?

Thanks,
Tia



Tia

Fractions
 
Thank you SOOOO much!

"Pete_UK" wrote:

To get the ¾ symbol, you need to hold down the Alt key and type 0190
on the numeric keypad at the same time. That way you can get:

1¾ Gallon Kit

in the cell (you probably don't need the space that separates 1 3/4 in
your example.

Hope this helps.

Pete

On Jan 23, 2:51 pm, Tia wrote:
I'm trying to enter 1 3/4 Gallon Kit into a cell, but I want the 3/4 to show
up smaller than the 1. Is there any way to do this?

Thanks,
Tia




Pete_UK

Fractions
 
You're welcome.

You might also want to know that Alt-0188 will give you this - ¼ - and
Alt-0189 will give you this - ½.

Hope this helps.

Pete

On Jan 23, 3:13*pm, Tia wrote:
Thank you SOOOO much!




All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com