View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
raj74 raj74 is offline
external usenet poster
 
Posts: 24
Default Greek Letter as a Text String

Hello James!!!!!!

Many thanks for your reply and sorry for replying late. I am not conversent
with uni code in excel. So if you can explain in little bit detail. Here
where I stuck..

I prepred a template of calculation in excel where there is inbetween checks
to see a coefficient (small sigma) calculated is greater than 1 or not. If it
less than 1 string will show "sigma is ok", if less than 1, "sigma is not ok".
I can not write the text string with symbol small sigma,I don't want sigma
to shown by a spelt text like "sigma" or any other english letter.
Hope I explain my proble.
Please help.

Regards

Raj


"James Silverton" wrote:

raj74 wrote on Mon, 22 Jun 2009 10:38:01 -0700:

I am trying to write a simple logical condition,
If A = 0, Sigma =1, other wise Sigma =2,


I write it using if function, but I cannot write the small
sigma symbol which is very annoying as the output is
considered. Tried with CHAR(number) but don't have any ascii
value for greek letters. Please help.



Insert Symbol should do the job in Excel if you switch to the Unicode
set of characters.

Lower case sigma is Unicode 03c3 by the way..If your Excel is as
antiquated as mine (2002), the ALT-X method does not work like in Word
etc.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not