View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fizz Richardson Fizz Richardson is offline
external usenet poster
 
Posts: 6
Default 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 fraction-formatted 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