Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Keyboard Shortcuts for Greek LettersHelpful Member!(4) 

MattGreer (TechnicalUser) (OP)
8 Oct 09 12:24
OK, so I use character map to find these things.  For the greek letter rho, in the Calibri font, the code reads "U+03C1".

I was used to typing "alt codes" to achieve these things, for example, to get the degree symbol °, I hold down the alt key and type "0176" on the number keypad.  This way, I don't have to go searching through the character map and I can just have a shortcut written down on my desk for such things.

Is there a way to translate "U+03C1" to an "alt code"?
 

Thanks!!


Matt

AnotherHiggins (TechnicalUser)
8 Oct 09 13:21
See this explanation of how to insert ASCII characters into Excel using the [Alt] key:
http://office.microsoft.com/en-us/excel/HA011331361033.aspx

As you'll see, Rho isn't available.

But if you change the font to Symbol, then you can just use r or R to produce the lower or upper case of Rho.

If you want to display Rho along with non-greek characters in a single cell, then you can select the R in the formula bar and just change the font for that single character.

-John
    The plural of anecdote is not data

Help us help you. Please read FAQ 181-2886 before posting.

Helpful Member!  fumei (TechnicalUser)
8 Oct 09 15:58
And, exactly, how do you know this is a question regarding Excel?  Just joshin' ya.

Type:  03C1, Alt-X

This = Unicode 03C1

03a1 will give the capital Rho in Calibri. You do not need to actually use the capitals (C, c, A, a - it does not matter).

The shortcut key shows on the Symbols dialog ("03C1, Alt-X") when - but only when - you have the from: dropdown set to Unicode(hex).

ك


0643, Alt-X....I have no idea what it says.

"A little piece of heaven
          without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

MattGreer (TechnicalUser) (OP)
8 Oct 09 16:37
I'm not really sure I understand, fumei.  I saw that instruction out there on the web, but it doesn't work for me in Excel (yep, this is in Excel, but I figured it would apply regardless of the MS product, perhaps I'm wrong).

I type 03C1, and then hit Alt-X, and nothing happens to the cell.  The cursor is still in that cell and the cell is still being edited.  When I thit the ALT-X the ribbon changes to the Add-Ins menu.

I tried hitting "enter" before hitting ALT-X, but still no joy.

What am I doing wrong?  I even tried it with the comma.

I'm not sure I understand what you're talking about regarding the "dropdown set to Unicode(hex)".  What is that?

Thanks!!


Matt

fumei (TechnicalUser)
8 Oct 09 16:44
Well slap me silly (with humble apologies to anotherhiggins!).  I am showing my Word bias.  You are correct, 03C1, Alt-X does NOT work in Excel (but does in Word).

Further, there is no "Keyboard shortcut 03C1, Alt-X" on the Insert Symbol dialog...but there is in Word.

Quote:

but I figured it would apply regardless of the MS product, perhaps I'm wrong)
You are wrong.

And so am I!

Sorry, it appears that this shortcut functionality is not included in Excel.  I just tried.  Nope.

"A little piece of heaven
          without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

MattGreer (TechnicalUser) (OP)
8 Oct 09 18:33
Thanks anyway!  I know how to accomplish what I need, I was just hoping for a shortcut.

Have a good weekend!

Thanks!!


Matt

Helpful Member!(3)  TonyJollans (Programmer)
8 Oct 09 18:50
It is possible to use Alt to enter hexadecimal values of Unicode characters, but it needs a registry tweak. The value is:

    HKCU\Control Panel\InputMethod\EnableHexNumpad

If it doesn't exist, create it as String (REG_SZ) value.

Set the (value of the Value) to "1", and reboot.

Now you can press and hold Alt and enter Num+ followed by the hex value (in this case 03C1) using the main keyboard and the numbers from the main keyboard, not the numeric keypad. When you release the Alt key, you should get your character, in  this case ρ

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

fumei (TechnicalUser)
13 Oct 09 15:59
That deserves a star.  Never knew that.

"A little piece of heaven
          without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

DaveInIowa (Programmer)
14 Oct 09 15:21
Would it be helpful to map these symbols to AutoCorrect Options? Then use something like:
?rho and ?degree to map to the rho and degree symbols?
Since "03c1" is obscure enough that it wouldn't be found in everyday data entry, you could even map the rho symbol to that series of characters.
GlennUK (MIS)
15 Oct 09 5:31
Hi Tony,

I never knew about EnableHexNumpad, ===> *

smile
 

Cheers, Glenn.

Beauty is in the eye of the beerholder.

MakeItSo (Programmer)
15 Oct 09 5:37
Once more, Tony, you amaze me. ***
I never knew that. This is veeery helpful!
thumbsup

"We had to turn off that service to comply with the CDA Bill."
- The Bastard Operator From Hell

TonyJollans (Programmer)
15 Oct 09 6:11
Thanks, chaps.

Looking at my post, I see a small typo ...

The registry key is actually ...\Input Method\... - that is there is a space between the two words. I think the "Input Method" key will always exist (just not the EnableHexNumpad value) and you shouldn't have to create a new key to put it in.

FWIW, I just checked and it still works in Windows 7 (not that I had any reason to think it wouldn't).

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close