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
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.