Character Codes

[Mitchell5656]

This is probably a really simple answer. I have a homework assignment for a Microsoft Office class, and it is requiring me to make the * with the character code 002A. I learned how to make character codes by pressing alt + (some number), but never with any letters. Please let me know how I can do this! Much appreciated.

 

[RoryA]

That is a hexadecimal code. 2A = 42 in decimal, so using Alt+42 should work.

 

[Mitchell5656]

Is there any other way to 002A besides converting it to Alt+42?

 

[RoryA]

You can do it in code with chrw(&H002A) or you can use character map but I don't know of any way to do it entering directly with the keyboard. Your class is very strange!

 

[Macropod]

In Word, simply type 002A, followed by Alt-x.

 

[Rick Rothstein]

You can do it in code with chrw(&H002A)

For hex numbers equal to, or less than, FF, you can use the Chr function (without the "w") as well...

Chr(&H002A)

Also, in Excel, you can use this formula in a cell (Mitchell5656's method doesn't work in an Excel cell)...

=CHAR(HEX2DEC("002A"))