converting data

[sghioto]

Have made an x-y scatter chart with temperature on the y axis and time
on the x axis.The data was imported and the temperature is in
centigrade.How can I convert the data into degrees fahrenheit? The
temperature data is in column B and contained in over 400 cells The
only way I know how to do this is manually converting each cell but
this will take forever.Can anyone show me how to convert the entire
column with a formula perhaps?

 

[Bob Umlas]

in C2 enter this & fill down:
=9*B2/5+32
Then copy column C & paste special values onto column B.

 

[Gord Dibben]

Sub convert()
Dim cel As Range
For Each cel In Selection
cel.Value = 9 / 5 * cel.Value + 32
Next cel
End Sub

Gord Dibben Excel MVP