I’m trying to read string fields from a tab delimited text file using StringValue but the field is being read first as a number and then truncated.
I have alphanumeric part numbers which should not be formatted as numbers, such as 60.5070 and 10.2060. Using StringValue these cells are read as 60.507 and 10.206 respectively.
How can I just read the raw data as is with no formatting/truncating?
Thanks.
Hi,
Well, I think you can set Workbook.ConvertNumericData to set it to false.
Thank you.
Hi Amjad,
This worked after setting ConvertNumericData to false before opening the workbook.
Thanks,
Neil