On Fri, 25 Apr 2008 17:51:26 -0700 (PDT), Pete_UK
brought the following to our attention:

Assume you want this on row 1 with your degrees starting in A2, put
this in A1:

=TEXT(A2,"0 deg")

Copy this across the row as required.

Hope this helps.

Pete

Thanks.. that expression is returning a #VALUE!

I'll also look in the Help section. Basically I'd like to pick up the
angle value and stick " deg" to it and make that cell a text string.

-G


On Apr 26, 1:47*am, wrote:
Several spreadsheet have a row of angles from 0 to 360° step 5° and it
would be great to create a row above that which has a character string
for use in the legend box. This new row would have the angle (0-360)
with " deg" concatenated. What is the expression for this row?

Example:

0 deg *5 deg 10 deg 15 deg

0, 5, 10, 15,

The expression must also work for angles from -180 to +180

* *-G