turtlepokerman
New Member
- Joined
- Jun 18, 2012
- Messages
- 28
Hello World,
I have a table of data that looks similar to this:
<tbody>
</tbody>
This structure repeats about 500x. I am importing data currently and the green arrows apprear in the corners and say numbers stored as text for rows B2:B4. How do I select all of the data in column B and have it automatically convert all of the numbers stored as text into numbers while leaving the text items alone? I am willing to work in VBA, since that I already have some functions created in it.
All help is appreciated!!!
I have a table of data that looks similar to this:
A | B | |
1 | Item1 | Apple |
2 | Item1Weight | 50 |
3 | Item1Height | 25 |
4 | Item2Length | 10 |
<tbody>
</tbody>
This structure repeats about 500x. I am importing data currently and the green arrows apprear in the corners and say numbers stored as text for rows B2:B4. How do I select all of the data in column B and have it automatically convert all of the numbers stored as text into numbers while leaving the text items alone? I am willing to work in VBA, since that I already have some functions created in it.
All help is appreciated!!!