Hi Neik,
another question if I may as I have not had to work with ratios in this
manner and do not know the standard in which they are expressed------

here is my actual formula and results:
cell K4 contains "# of Tops"
cell k5 contains "# of Pants"
=SUBSTITUTE(TEXT(K4/K5,"?/?"),"/",":") results = 15:7
=SUBSTITUTE(TEXT(K5/K4,"?/?"),"/",":") results = 1:2

Since I want to find the ratio of Tops to Bottoms, I expected to see 2:1,
not 15/7. The people that will be using this spreadsheet will also expect
2:1 and will not be happy with 1:2.
Suggestion?
"Niek Otten" wrote:

Hi Jane,

=SUBSTITUTE(TEXT(A1,"?/?"),"/",":")

--
Kind regards,

Niek Otten

"Jane" wrote in message
...
I want my result to be expressed as a ratio:

4:1

thank you, jane