Thank you Niek!

now how would I fit that in if in my cell I have a formula? in cell K6, I
have a simple formula ... =M9/M8. it's the result that I need as stated
below.

I do appreciate your help!

"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