see
Unicode, Working with in Excel
http://www.mvps.org/dmcritchie/rexx/htm/unicode.htm
create CharW macro User Defined Function
For help installing a macro or userdefined function (UDF) see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
=personal.xls!CharW(955) decimal equivalent of hex 03BB
lambda is 6C in the Symbol font, decimal 108
enter as Alt+0108 (in the symbol font)
I have charmap within my menus, see
http://www.mvps.org/dmcritchie/rexx/...ls.htm#charmap
but if you want an addon see Chip Pearson's symbolizer
http://www.cpearson.com/excel/chars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Jake" wrote in message ups.com...
Hello,
I'm trying to create some shortcuts to enter Greek letters into cells
in Excel. The =CHAR() works for most characters, but the unicode/hex
for the Greek letters is 03BB (lambda, for example) but nothing
recognizes the alpha characters. If I go to the symbol font I can enter
l for lambda, but I'd like something fast and easy, and not have to go
to the mouse to change fonts. I tried a macro that changes fonts, but
it doesn't work while typing in a cell...it changes it, and then
everything that then gets typed into the cell is that font. That isn't
normally what I want.
An add-in would work as well, but I haven't found one. Any ideas?
Thanks.
Steven