View Single Post
  #1   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 ??

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??