Forum Discussion
chicks
13 years agoRegular Contributor
Hi Robert,
Thanks for your response. The behavior I'm seeing does not match my understanding of your reply.
If the driver is assuming that the value is numeric based on the first few characters and then returning a null when it hits
a non-numeric character, I would assume that this happens consistently. In other words, a cell value starting with numeric
characters and then including a non-numeric character would NEVER be read as other than null.
However, I am successfully reading the mixed character case after creating a brand new column and using the same sequence
of characters that failed previously.
Also, I tried preceding the value with an apostrophe and still got a NULL response. As well as changing the formatting from 'general'
to 'text'.
What am I missing? Thanks. Curt
Thanks for your response. The behavior I'm seeing does not match my understanding of your reply.
If the driver is assuming that the value is numeric based on the first few characters and then returning a null when it hits
a non-numeric character, I would assume that this happens consistently. In other words, a cell value starting with numeric
characters and then including a non-numeric character would NEVER be read as other than null.
However, I am successfully reading the mixed character case after creating a brand new column and using the same sequence
of characters that failed previously.
Also, I tried preceding the value with an apostrophe and still got a NULL response. As well as changing the formatting from 'general'
to 'text'.
What am I missing? Thanks. Curt