Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with symbols
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |