Is there anyway of doing this? ie having 12.5 displayed as a fraction?
Any ideas would make my Dad very happy :) |
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. |
Cheers dude, quite why I couldn't think of that I'll never know
|
Just clicked Help in Excel and typed "Fractions" ;)
|
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? |
Sorted, thanks Dunk. :D
Don't worry the old fella isn't upto formulas anway, purely for display purposes ;) |
¼ = 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] |
All times are GMT +1. The time now is 01:50 AM. |
© 2024 MH Sub I, LLC dba Internet Brands