Free Support Forum -

StringValue problem with tab delimited files

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?



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.