How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal

T

temp

How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2

Greets All

I have one column that has the angles in 20 degrees increments up to 720 degrees
Is thier a way for excel to show them in Radian in symbolic format? I've already converted them to radians by
multipling angle*PI()/180 but how do I get it to look it symbolicly?

Example

180 degrees would look like (symbol Pi)
90 degrees would look like (Symbol Pi/2)

Tia sal2
 
H

Harlan Grove

temp said:
How can I show radians in symbolic format in excel? like 90 degrees
would show (Symbol Pi/2) tia sal2
Click to expand...
...

You mean you want it to display as ð/2? You could enter p/2 then
change the typeface for the cell to Symbol.
 
J

Joel

Try custom formating. I enter the line below into custom formating on the
worksheet

# "Pi" ?/2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show 4
How to do I convert angles from radians to degrees in Excel? 2
How can I make Excel save Unicode CSV data correctly? 0
how can I show a flashing symbol in an Excel sheet? 2
In Excel how can I add symbol to entire column? 4
How can I make a "Clock" chart in Excel 0

Top