Symbol for pi

[inarbeth]

Does anyone know how to insert the symbol for pi into a spreadsheet?

 

[inarbeth]

Jay sorry I was deleting my duplicate post whilst you were replying to it. The answer is buried away in Excel isn't it? - I'd looked at all the CHAR items and did not realise p equalled pi. My next problem. I want to have text in a standard font plus the symbol for pi in the same cell. I want to use the formula: ="A times "&CHAR(112) &"equals" but cannot format the "A times " and the "equals" bits differently from the Symbol format for pi. Is there a way round this?

 

[Jay Petrulis]

Hi,

You'll have to do it using the Insert Symbol from the Insert menu.

You can also do it in code. Turn on the macro recorder and do the steps. What results indicates that you will have to manipulate the text characters using the .Characters property.

 

[leibale]

you can convert the formula to text (F2, F9), then in select in the formula bar only the "p" character, and then apply a font to it

 

[inarbeth]

Thanks guys. Leibale how does F2 F9 work?

 

[Scott R]

Enter the following in your cell:
A times P equals

Drag over the P character in the formula bar.
Format Cells Font as Symbol. Enter.

 

[inarbeth]

On 2002-09-17 14:33, Scott R wrote:
Enter the following in your cell:
A times P equals

Drag over the P character in the formula bar.
Format Cells Font as Symbol. Enter.

Thanks Scott, I've got that. Can you help with the F2 F9 query?

 

[Scott R]

liebale is converting a formula to text by hitting F2 and then F9, and then formatting the p character using Format Cells Font.

Mine is a similar except I'm suggesting you start with text in the cell and skip the CHAR approach.

 

[inarbeth]

Thanks Scott, skipping the CHAR approach works perfectly for what I want. It would have been helpful of Microsoft to mention the Symbol font in the help section for pi!