By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,988 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,988 IT Pros & Developers. It's quick & easy.

Help with Code

P: 1
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
Nov 15 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 267
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"
Nov 15 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.