Degrees celsuis

L

Louise C.

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
 
J

James Silverton

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

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.
 

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

Top