How to show format number to show degrees Celsius

Question

I have a sheet of temperatures that I want to graph but also show want to indicate that they are in degrees Celsius in the table, i.e., 10°C.

Answer 1

Hello !

You'll need to use a custom number format : type your temperature in the cells, select those cells, press Ctrl +1 to open the "Format cells" window.

Go to Number > Custom, and in "Type", enter 0"°C"

Click "OK".

This way, Excel will always display the Celsius sign next to your tempature, but without altering the data (it's still a number).

Please let me know if you have any other question !

Answer 2

Use a custom number format so the cell still contains a numeric value but displays the °C suffix.

1. Select the temperature cells.
2. On the Home tab, in the Number group, open the Number Format dropdown and choose More Number Formats (or Format Cells).
3. Go to the Number tab and select Custom.
4. In Type, enter a format such as:
   • 0"°C" for whole numbers (10°C)
   • 0.0"°C" for one decimal place (10.5°C)
5. Select OK.

The values remain numeric for calculations and charts, but display with °C in the worksheet and in data labels on charts.

---

References:

• Display dates, times, currency, fractions, or percentages
• Change numbers with text format to number format in Excel for the web