Showing the degrees symbol in a formula

[andrewb90]

Hello all,

Is there a way to have the format of a cell set to display degrees? I have the formula

= A12

in the cell, but I want the number to appear with the degree symbol.

Any possible way to do this?

Thanks

 

[kevatarvind]

select the cell and then Go to Cell Format there Custom format paste below format

0"°"

or want to use in formula then try below formula

=A12&"°"

 

[Akashwani]

Hi Andrew,

Does this work for you?...

=A12&CHAR(176)

OR

=A12&" "&CHAR(176)

I hope that helps.

Ak

 

[andrewb90]

0"°" worked perfectly! thanks!

 

[kevatarvind]

Your Welcome