Excel 2007 and Unicode

Posted by pjlasl on Stack Overflow See other posts from Stack Overflow or by pjlasl
Published on 2010-05-24T22:07:32Z Indexed on 2010/05/24 22:11 UTC
Read the original article Hit count: 392

Filed under:
|
|
|
|

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?

© Stack Overflow or respective owner

Related posts about excel

Related posts about unicode