Hello bos ? anyone can help me, how write √ in a cell with Excel Macro for Alt + 251 ( like this √ ).
thank's b4![]()
Hello bos ? anyone can help me, how write √ in a cell with Excel Macro for Alt + 251 ( like this √ ).
thank's b4![]()
Last edited by antoni; 09-28-2009 at 11:50 PM.
=CHAR(214) returns √ in the Symbol font
Entia non sunt multiplicanda sine necessitate
Hello antoni,
When you say "macro" in this forum, you should qualify the term. If you don't, it is assumed you mean a VBA macro and not a worksheet function.
In VBA you can use ChrW to access both ANSI and Unicode character sets. Generally, this far more useful a function when dealing with special characters or foreign alphabets. However, it can not be used with the MacIntosh environment.
The ChrW function returns a String containing the Unicode character except on platforms where Unicode is not supported, in which case, the behavior is identical to the Chr function (ANSI).
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks