formatcellsnumbercustom

Type

0.0

then hold down alt key while typing 0176 on the numpad, release alt key

Peo



"Biff" wrote in message
...
Hi!

You can just add the ° symbol to your Custom Number format.

Well, that's the problem! I don't know what that custom number format
would be!

Thanks!

Biff

"Elkar" wrote in message
...
You can just add the ° symbol to your Custom Number format. Hold down
the
Alt key and type 0176.

HTH,
Elkar


"Biff" wrote:

Hi folks!

Working on a project and using a formula like this just so we can get
the
degree sign:

=TEXT(ROUND(DEGREES(ATAN2((C6-C30)/2,A25)),1),"0.0")&CHAR(176)

This obviously results in a text value.

How can I dump the TEXT function and the CHAR function and format the
cell
to display the degree sign and still be a numeric data type?

Thanks!

Biff