Thread
:
RATIO number format
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
Posts: n/a
RATIO number format
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
Reply With Quote