Hello,
I am trying to use vba to create an excel spreadsheet. The problem I am having revolves around 1 column. Some of the values in the column are numeric (eg, 1). There are a few with a value 09, which are coming in as text. I would like to do automation with vba, but I can't get these values converted to the same datatype.
I cannot even get the data into an access table because of these values.
I don't understand how this could have happened - I recieved the worksheet and was asked to do these things with it.
Any thoughts on what I can do about this aside from manually making the changes?
I am trying to use vba to create an excel spreadsheet. The problem I am having revolves around 1 column. Some of the values in the column are numeric (eg, 1). There are a few with a value 09, which are coming in as text. I would like to do automation with vba, but I can't get these values converted to the same datatype.
I cannot even get the data into an access table because of these values.
I don't understand how this could have happened - I recieved the worksheet and was asked to do these things with it.
Any thoughts on what I can do about this aside from manually making the changes?