Well, all I can say is........Doh!

Sometimes I'm so "thick" it's not funny. LOL!

Thanks to everyone for responding.

Biff

"Biff" wrote in message
...
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