To put in short my assignment, I have been given a table to show 2 areas, Chicago and Dublin and the temperatures in Fahrenheit for a 12 month period see information below
CHICAGO:
January: 21.2
February: 25.7
March: 36.7
April: 48.6
May: 59.0
June: 68.4
July: 73.0
August: 71.8
September: 64.2
October: 52.5
November: 39.7
December: 27.3
DUBLIN
January: 40.6
February: 41.0
March: 42.6
April: 46.0
May: 50.7
June: 55.9
July: 59.0
August: 58.3
September: 54.9
October: 49.5
November: 44.1
December: 41.7
I need to:
input the temperatures in a well desiged form which i have done
I need a CODE for converting the Fahrenheit temperatures which are given above to Centigrade
hi
is the data supplied in a file ?
do you want a VB (own form) or VBA (Exel) code?
'TempF is temp in Fahrenheit
'TempC is temp in Celcius
'convert F 2 C
TempC = Format((TempF - 32) * 5 / 9, "0.0") & " C"
'convert C 2 F
TempF = Format(TempC * 9 / 5 + 32, "0.0") & " F"