View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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??