473,324 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Help with Code

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
1 923
albertw
267 100+
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

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

Similar topics

4
by: PHPkemon | last post by:
Hi there, A few weeks ago I made a post and got an answer which seemed very logical. Here's part of the post: PHPkemon wrote: > I think I've figured out how to do the main things like...
6
by: d.warnermurray | last post by:
I am doing a project for school that involves creating help files for a html authoring tool. If you could help me with answers to some questions it would really help. 1. What tasks do you expect...
6
by: Mark Reed | last post by:
Hi all, I am trying to learn a little about programming (I know next to nothing so far) and have found some code which hides the toolbars. However, this bit of code is a little too effective and...
4
by: dixie | last post by:
Help, I'm really out of my depth here (not unusual I hear you say :-). I have just installed HTML Help in an application. I told it in the Project Properties the path to the help file. I then...
7
by: Timothy Shih | last post by:
Hi, I am trying to figure out how to use unmanaged code using P/Invoke. I wrote a simple function which takes in 2 buffers (one a byte buffer, one a char buffer) and copies the contents of the byte...
23
by: Jason | last post by:
Hi, I was wondering if any could point me to an example or give me ideas on how to dynamically create a form based on a database table? So, I would have a table designed to tell my application...
16
by: Allen | last post by:
I have a class that returns an arraylist. How do I fill a list box from what is returned? It returns customers which is a arraylist but I cant seem to get the stuff to fill a list box. I just...
3
by: inkexit | last post by:
I need help figuring out what is wrong with my code. I posted here a few weeks ago with some code about creating self similar melodies in music. The coding style I'm being taught is apparently a...
1
by: glenn123 | last post by:
Hi, i am just about out of time to produce a working jukebox which has to perform these functions: to play music files when a track is chosen from a list which when the user presses the change genre...
10
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that Microsoft's Office 2003 help system is horrible, probably...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.