Calculation Problem

I am trying to write a calculation that converts from Farenheit to Celcius, if I convert 1 degree Farenheit to Celcius I get an answer of 17.222 which should be -17.222, I am not getting the - symbol in the answer, my code is as follows.

dim ratio as double
dim ratio1 as double
dim ratio2 as double
ratio = val(txtfaren.text)
ratio1 = (ratio - 32)
ratio2 = ratio1 * 5/9
txtfaren1.Text = Format(ratio2,“0.000”)


You need to add - to the format “-0.000” to get the negative sign to show. You should probably also use # for the first 0 to allow for multiple digits before the period “-#.000”.

Many Thanks Wayne.