unicode

O

oldLearner57

hi community

when I press the Alt+155, it gave me ">" this sign but how to change the
Alt+155 to display the symbol of "cent" - like if I press Alt+162 ?...

thanks community for assistance
 
S

ShaneDevenshire

Hi,

To really change the key assignments for the Alt+155 combination, I suspect
you would need to do it outside Excel, and it would apply throught all
Windows programs.

However, why not assign the symbol to a simplier shortcut key combination
like Ctrl+e or Ctrl+Shift+C

You can do key assignments in Excel but they are only prepared to handle a
single key or a key in combination with Shift, Alt, or Ctrl.

Here is the code to enter the cent symbol in the active cell.

Sub Cents()
ActiveCell = "¢"
End Sub

You can assign a shortcut key once you have put this code in a module.

Move back to Excel and choose Tools, Macro, Macros. Select the Cents macro
and click Options. In here hold down the Shift key and press the letter you
want to assign or just type the letter without the Shift key.

If you want the shortcut key available in all the workbooks you open put the
code in the Personal Macro Workbook.

The easiest way to do this is to choose Tools, Macro, Record new macro,
Enter the name Cents and from the drop down for Store macros in pick Personal
Macro Workbook. Click OK. Choose Insert, Symbols, Normal text, find and
select the cent sign, click the Insert button and then the Close button and
press Enter. Stop the recorder by choosing Tools, Macro, Stop Recording.

You have added the macro to the file, assign the shortcut key as described
above. And when you close out of Excel, respond Yes to saving the changes to
the Personal.xls file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top