# Temperature Conversion in Excel

**Excel 2007** and **Excel 2010** make it easy to convert between different units, such as temperatures using the `CONVERT()`

function.

It is used as follows: `=CONVERT(number, from_unit, to_unit)`

. Where:

`number`

is the temperature you want to convert`from_unit`

is the symbol of the unit you want to convert from, e.g. “C” for Celsius, “F” for Fahrenheit, or “K” for Kelvin. If you start typing the formula, Excel will pop up a list of options for you to choose from. Remember to use quotes, e.g. “C”.`to_unit`

is the symbol of the unit you want to convert to.

## Examples

- Convert 40°C to °F:
`=CONVERT(40, "C", "F")`

- Convert -40°F to °C:
`=CONVERT(-40, "F", "C")`

- Convert 0°K to °C:
`=CONVERT(0, "K", "C")`

You can also store the value to convert in a cell, and use the formula to output the converted cell. For example, if you type the input °C value in cell A1, you could use the following to convert it to Fahrenheit: `=CONVERT(A1, "C", "F")`

## Comments