converting data

  • Thread starter Thread starter sghioto
  • Start date Start date
S

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?
 
in C2 enter this & fill down:
=9*B2/5+32
Then copy column C & paste special values onto column B.
 
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
 
Back
Top