Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unicode Problem
Tried in 2007..
1. Appear as Û«alphaÛ«omega 2. Appear as Û«alphaÛ«omega 3. Refer point 2 4. Appears as Û«alph Is this something to do with the language settings/or any over running events. If this post helps click Yes --------------- Jacob Skaria "Gary''s Student" wrote: I am having a small problem with Unicode character 1771 (6EB). When I run: Sub uniMagic() s = ChrW(1771) With Range("A1") .Font.Name = "Arial Unicode MS" .Value = s & "alpha" & s & "omega" .Offset(0, 1).Value = Left(.Value, 5) End With End Sub I noticed: 1. the positions of "alpha" and "omega" are reversed in the cell A1 2. the positions of "alpha" and "omega" are reversed in the formula bar 3. the formula br has the text way to the right rather than the left 4. the value in B1 seems to indicate that the left-most part of A1 really IS "alpha" What is happening?? -- Gary''s Student - gsnu200847 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unicode | Excel Discussion (Misc queries) | |||
problem after changing non-unicode language | Excel Discussion (Misc queries) | |||
Unicode | Excel Worksheet Functions | |||
CSV and Unicode (or UTF-8) problem | Excel Discussion (Misc queries) | |||
CSV and Unicode (or UTF-8) problem | Excel Discussion (Misc queries) |