I got it myself!
THANK YOU AGAIN!

"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