Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    On Excel 2007, is there a pre-built function that will convert an entire column of degrees Fahrenheit to Celsius? With over 1000 data points I'd prefer not to do this 1 x 1 if I don't have to.
    Thanks

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by Honu View Post
    On Excel 2007, is there a pre-built function that will convert an entire column of degrees Fahrenheit to Celsius? With over 1000 data points I'd prefer not to do this 1 x 1 if I don't have to.
    Thanks
    The CONVERT function example: =CONVERT(A1,"F","C")
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Catharine Richardson - WebGenii View Post
    The CONVERT function example: =CONVERT(A1,"F","C")
    Thanks. I had seen that but it doesn't seem to allow converting more than a single cell at a time. I'm sure I'm missing something though. Is there a way to use CONVERT on a range of cells (in this case, a full column)?

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    If you have a column of farenheit figures - enter the formula in the next column and copy the formula down.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Honu View Post
    Thanks. I had seen that but it doesn't seem to allow converting more than a single cell at a time. I'm sure I'm missing something though. Is there a way to use CONVERT on a range of cells (in this case, a full column)?
    Select an empty column - in the formula bar type =CONVERT(A1,"F","C"), then hit Control + Enter. This will set the formula for every cell in the column.

    If you want to replace the values in the original column, select the column you have just populated, copy it to the clipboard and Paste Special | Values over the original column.

  6. #6
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Catharine Richardson - WebGenii View Post
    If you have a column of farenheit figures - enter the formula in the next column and copy the formula down.
    I'm not sure exactly what you mean by "copy the formula down." What I've done is to copy the formula, paste it into the next row down, and manually replace the number cell information. For example, delete "B3" and type in "B4." Is that what you mean?

    Thanks, sorry for being thick.

  7. #7
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Got it! Thanks, WebGenii and Gfamily!

  8. #8
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Honu View Post
    I'm not sure exactly what you mean by "copy the formula down." What I've done is to copy the formula, paste it into the next row down, and manually replace the number cell information. For example, delete "B3" and type in "B4." Is that what you mean?

    Thanks, sorry for being thick.
    Select Cell B3, the bottom right corner is a black box. When your mouse goes over it, the cursor changes from a large white cross to a thin black cross.
    While it's a black cross, click and (holding the button down) drag downwards for several cells. Release. The formula will fill all the cells you have selected.

    That's what's called 'copying the formula down',

  9. #9
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks - my Excel skills (never great) have gotten very rusty.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •