On Fri, 14 Dec 2007 10:36:29 -0800, Harlan Grove wrote:

temp wrote...
...
20 degrees ---- 0.34906585 Radians ---- I want to convert it to show
up as Pi/9 in excel in another column 40 degrees ----
0.698131701Radians---- I want to convert it to show up as 2Pi/9 in
excel in another column
...

If cell A1 contained the angle in degrees, the following formula will
convert it to a TEXT REPRESENTATION in radians.

=TRIM(SUBSTITUTE(SUBSTITUTE(TEXT(A1/180," ?\p/??")," 1p","p"),"/1 ",""))

But you'd need to change the font's typeface to Symbol for the cells
containing such formulas. Doing so produces the following results.

0 0π
15 π/12
20 π/9
30 π/6
45 π/4
60 π/3
75 5π/12
90 π/2
180 π
270 3π/2

where π is the symbol for pi in Google Groups reply box.

Thanks works great and it's nice and simple too :-)