#1   Report Post  
Posted to microsoft.public.excel.misc
Tia Tia is offline
external usenet poster
 
Posts: 64
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
Tia Tia is offline
external usenet poster
 
Posts: 64
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fractions smakee Excel Discussion (Misc queries) 2 December 17th 07 05:24 PM
Fractions Angel1 Excel Discussion (Misc queries) 4 October 18th 06 06:54 PM
about fractions patrick Excel Discussion (Misc queries) 4 March 30th 06 03:27 AM
Fractions V Excel Discussion (Misc queries) 5 September 14th 05 04:00 PM
fractions help splitsixty Excel Discussion (Misc queries) 6 August 2nd 05 11:03 PM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"