Excel 2007 and Unicode
- by pjlasl
I have an israeli spreadsheet reading right to left. When I read the values (using VBA) it places a question mark (?) at the beginning and end of the text, in other words it wraps the text with the question mark (ie ?0123456?).
If you type Range("A2").value or .value2 or .text the results are the same.
Any idea on how to prevent this?