Degrees celsuis

  • Thread starter Thread starter mary
  • Start date Start date
I presume you are just looking for a display option.
In FORMAT/CELLS/Number choose "Custom" (at the bottom of the category list).
Define your custom cell format as #°. This will display a degree symbol after the number.

HTH
Louise

----- mary wrote: -----

Does anybody know how to format cells into degrees?
Thanks
Mary
 
mary said:
Does anybody know how to format cells into degrees?
Thanks
Mary
Click to expand...

This seems to work: Format Cells....Custom ###"°C".

I don't know if it will arrive by e-mail but there is a degree sign after
the first ".

Jim.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical Test - Returning Value 3
how do i use symbol of degree in excell work sheet using key board 2
How do I display numbers as Degrees Centigrade? 1
Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Foot mark aka single quote mark? 3
Sexagesimal degrees calculations 0
How do I represent values in Degrees Minutes Seconds in Excel? 2
Degrees Minutes Seconds 3

Back
Top