MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format in Degrees


Posted by DAvid on October 04, 2000 1:02 AM

I WOULD LIKE TO FORMAT A CELL AS DEGREES CELSIUS
THE DEGREE SIGN IS MADE WITH ALT+0176. I AM NOW JUST TAKING THE CELL I WANT AND ADDING THE DEGREE'S C ON TO THE END. IS THERE A WAY TO DO A CUSTOM FORMAT ON THE CELL TO MAKE IT ALWAYS BE "°C"


Posted by Celia on October 04, 2000 1:31 AM


David
Custom format :- 0 "°C"
Use Alt+0176 to enter the ° in the custom format box.
Celia

Posted by David on October 04, 2000 2:48 AM

Thanks