tags:

views:

22

answers:

0
Q: 

Excel 2007 and Unicode

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?

related questions

Difference between VARCHAR2(11 BYTE) and VARCHAR2(11 CHAR)
How to remove these kind of symbols (junk) from string?
Problem with unicode String literal in unit test
How to replace a character programatically in Oracle 8.x series
Best way to convert text files between character sets?
international characters in Javascript
What do I need to know to globalize an asp.net application?
Are you fluent in Unicode yet?
Unicode in C++
Getting international characters from a web page?
MySQL UTF/Unicode migration tips
Reading Email using Pop3 in C#
cross platform unicode support
Formatting tabular data using unicode characters
'Reliable' SMS Unicode & GSM Encoding in PHP
How do I put unicode characters in my Antlr grammar?
Are named entities in HTML still necessary in the age of Unicode aware browsers?
Unicode vs UTF-8 confusion in Python / Django?
Regex and unicode
How can I get Unicode characters to display properly for the tooltip for the IMG ALT in IE7?
String To Lower/Upper in C++
How to display unicode text in OpenGL?
Is it just me, or are characters being rendered incorrectly more lately?
Python, Unicode, and the Windows console
Internationalization in your projects