| || |
Problem in removing Apostrophe in excel
In VBS I'm using ADODB to maniplate excel sheet. When I'm inserting any data to the excel sheet then the string is updated in the excel sheet preceded with an Apostrophe.
e.g. I want to insert "ABCD".But it is geting updated as "'ABCD".
How to avoid this?
Note: If i'm checking the values in message box then it is appearing as "ABCD"
Re: Problem in removing Apostrophe in excel
This happens for enforcing text formatting. You should not worry about it as the values would actually be considered as ABCD only and not 'ABCD