do you mean like
x= 7
y=5
z = x /y
msgbox "1:" & z



"Gareth Wretham" wrote in message
...
I want to calculate the ratio of two values and present it in the form
x : y

I then want to multiply that ratio by 1 : 2 and present the answer in
the form x : y

thanks.