Keyboard Shortcut for Unicode (hex)

martiniextradry

Board Regular
Joined
Mar 4, 2008
Messages
73
How do I enter a symbol with the keyboard when it's a Unicode?

I know how to do ASCIIs (by holding Alt and typing it's four digit code) but I now need to enter a 1/8 symbol which is Unicode 215B.

Anyone know if it can be done?

Mart
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Which OS are you using? On Windows XP it can be done with a registry tweak if you're comfortable with that?
 
Upvote 0
Well without it, I think you are stuck using the Character Map program to copy and paste special symbols. Most of the shortcuts that work in word processing apps don't seem to work in Excel. I'll give you the tweak anyway and you can decide whether to use it!
1. Open the registry editor (Start-Run, type 'Regedit' without the quotes and press Enter)
2. Navigate to (and select) HKEY_CURRENT_USER\Control Panel\Input Method and you will probably see two keys in the right hand pane ((Default) and 'Show status')
3. Choose Edit-New-String Value from the menu, name the key EnableHexNumpad, then double click it and change the Value to 1.
4. Reboot.
Now in Excel you should be able to hold down Alt and type + on the number keypad followed by 215b and then release Alt.
HTH
 
Upvote 0
For an easier method, copy and paste the following into Notepad, save it as tester.reg and then double-click it in explorer:

Code:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Control Panel\Input Method]
"EnableHexNumpad"="1"
 
Upvote 0
Will this work in Windows 7?

For an easier method, copy and paste the following into Notepad, save it as tester.reg and then double-click it in explorer:

Code:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Control Panel\Input Method]
"EnableHexNumpad"="1"
 
Upvote 0

Forum statistics

Threads
1,214,605
Messages
6,120,473
Members
448,967
Latest member
visheshkotha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top