Home 
Search 
Today's Posts 
#1




how do I format an Excel sheet to create a ratio as in 1:25 ??
when doing calculations I want the answer toi come out as a ratio 1: 25
rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? 
#2




how do I format an Excel sheet to create a ratio as in 1:25 ??
On 30 Aug, 13:08, Fizz Richardson
wrote: when doing calculations I want the answer toi come out as a ratio 1: 25 rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? Hi Fizz, This isn't the whole answer, but it might help..... If you type the ratio into the cell as a fraction (eg for 1:25 type it as 0 1/25) it will appear as a fraction format, 1/25. Similarly your ratio can be typed into a fractionformatted cell as a decimal (eg 0.5 will appear a 1/2). I say it's only half an answer since I can't yet see a way to use the ":" separator instead of the "/"  but I'm sure one of the experts here might be able to find a way to do that, if it exists. HTH Phil 
#3




how do I format an Excel sheet to create a ratio as in 1:25 ??
If you have a number of 24.8, and format the call as "1:"0 , then it will
display as 1:25. If you wanted it in a different cell, you can use the formula ="1:"&TEXT(A1,0) to produce a text string.  David Biddulph "Fizz Richardson" wrote in message ... when doing calculations I want the answer toi come out as a ratio 1: 25 rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? 
#4




how do I format an Excel sheet to create a ratio as in 1:25 ??
Hi David
ths for that  as I said I have found that I can use the inverted commas to force the colon  but it can't then round the answer so somewhere I was hoping that there might be another way of getting te same effect. "David Biddulph" wrote: If you have a number of 24.8, and format the call as "1:"0 , then it will display as 1:25. If you wanted it in a different cell, you can use the formula ="1:"&TEXT(A1,0) to produce a text string.  David Biddulph "Fizz Richardson" wrote in message ... when doing calculations I want the answer toi come out as a ratio 1: 25 rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? 
#5




how do I format an Excel sheet to create a ratio as in 1:25 ??
ths  you can force the colon to show by making Excel think that it's text
(put inverted comas either side) but this doesn't quite do what I want. But thnks for the suggestions. "Phil" wrote: On 30 Aug, 13:08, Fizz Richardson wrote: when doing calculations I want the answer toi come out as a ratio 1: 25 rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? Hi Fizz, This isn't the whole answer, but it might help..... If you type the ratio into the cell as a fraction (eg for 1:25 type it as 0 1/25) it will appear as a fraction format, 1/25. Similarly your ratio can be typed into a fractionformatted cell as a decimal (eg 0.5 will appear a 1/2). I say it's only half an answer since I can't yet see a way to use the ":" separator instead of the "/"  but I'm sure one of the experts here might be able to find a way to do that, if it exists. HTH Phil 
#6




how do I format an Excel sheet to create a ratio as in 1:25 ??
If you want to round the number, rather than merely display it rounded, you
can use the ROUND function and then format as discussed below. Another option is to use Tools/ Options/ Calculation: Precision as displayed, and then the rounding in the display will be carried into the stored number.  David Biddulph "Fizz Richardson" wrote in message ... Hi David ths for that  as I said I have found that I can use the inverted commas to force the colon  but it can't then round the answer so somewhere I was hoping that there might be another way of getting te same effect. "David Biddulph" wrote: If you have a number of 24.8, and format the call as "1:"0 , then it will display as 1:25. If you wanted it in a different cell, you can use the formula ="1:"&TEXT(A1,0) to produce a text string.  David Biddulph "Fizz Richardson" wrote in message ... when doing calculations I want the answer toi come out as a ratio 1: 25 rather than just 25  I have found a way of doing that by adding the 1: as text within inverted commas  but it won't allow a rounding. Does anyone know another way of doing this pls?? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Ratio  How To Create Your Own Function/Formula  Excel Worksheet Functions  
Divide x/y should give Ratio x:y,How to express ratio in excel  Excel Worksheet Functions  
RATIO number format  Excel Worksheet Functions  
How do I calculate and display ratio ( format 3.5:2)  Excel Worksheet Functions  
How do I create a ratio function in Excel?  Excel Worksheet Functions 