Displaying fractions in Excel
11 June 2003, 09:27 PM
#2
Scooby Regular
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes
on
0 Posts
This is how to do it in OfficeXP/ExcelXP. I presume it is the same in earlier versions.
Display numbers as fractions or percentages
Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
Do one of the following:
To display numbers as fractions, click Fraction in the Category list, and then click the type of fraction you want to use.
To display numbers as percentages, click Percentage in the Category list. In the Decimal places box, enter the number of decimal places you want to display.
To quickly display numbers as percentages of 100, click Percent Style on the Formatting toolbar.
Note Numbers above 1 are automatically entered as percentages; and numbers below 1 are converted to percentages by multiplying by 100. For example, entering 10 results in 10%, and entering .1 results in 10%. To have all numbers converted by multiplying by 100, on the Tools menu, click Options, click the Edit tab, and then clear the Enable automatic percent entry check box.
Display numbers as fractions or percentages
Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
Do one of the following:
To display numbers as fractions, click Fraction in the Category list, and then click the type of fraction you want to use.
To display numbers as percentages, click Percentage in the Category list. In the Decimal places box, enter the number of decimal places you want to display.
To quickly display numbers as percentages of 100, click Percent Style on the Formatting toolbar.
Note Numbers above 1 are automatically entered as percentages; and numbers below 1 are converted to percentages by multiplying by 100. For example, entering 10 results in 10%, and entering .1 results in 10%. To have all numbers converted by multiplying by 100, on the Tools menu, click Options, click the Edit tab, and then clear the Enable automatic percent entry check box.
12 June 2003, 08:40 AM
#5
Scooby Regular
Thread Starter
Join Date: Aug 2002
Location: Sodding Chipbury
Posts: 2,702
Likes: 0
Received 0 Likes
on
0 Posts
The plot thickens....
What he actually wants is to display 1/2, like that but taking up 1 character instead of 3 (if you get my drift)
Any way other than pasting in a bitmap or something?
What he actually wants is to display 1/2, like that but taking up 1 character instead of 3 (if you get my drift)
Any way other than pasting in a bitmap or something?
06 December 2003, 08:51 AM
#7
Moderator
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
¼ = Alt+0188
½ = Alt+0189
¾ = Alt+0190
Not sure that Excel will include them as part of a formula/sum though.
[Edited by DJ Dunk - 6/12/2003 8:52:14 AM]
½ = Alt+0189
¾ = Alt+0190
Not sure that Excel will include them as part of a formula/sum though.
[Edited by DJ Dunk - 6/12/2003 8:52:14 AM]
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM