The Excel help says typing the Unicode hexadecimal code followed by Alt-X will display any Unicode character (e.g. 20AC, Alt-X for €), just like in Word. It says:
"[Alt-X] Pressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character...
I've been able to make a spreadsheet that will put a date stamp in a cell (e.g. Now) when another cell has been populated. Below is the code that I've found and slightly tweaked and it works great as designed. For example, if I type the word "true" in A4, it puts the value of =NOW in cell C6...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.