My Excel data is incorrectly read as "00:00:00" instead of "ABC"

[Pardeep]

Not sure what is happening here, but Select tool keep reading my excel data as "00:00:00" instead of "ABC". Looked in my excel file, data is formatted as string. Select tool recognizes data as string but spits out wrong information.

Can someone please let me know what am I missing here? Thank you

[binuacs]

@Pardeep Can you connect to the input tool to a browse tool and check the field processor and name?

[Pardeep]

@binuacs Even the Browse tool is showing wrong data output

[binuacs]

@Pardeep Can you check the input file again? your screenshot shows the file name as DLB January 09 vf.xlsm but the input file showing DLB - January 11 vf.xlsm

[Pardeep]

@binuacs Sorry for the confusion.. Both files are same, we just create a new workbook every day. So you see the different names.. I also checked the file I am reading in my Alteryx workflow, data is correct in it. When I look for type of data in those columns in Excel, its returns 2 (string value) as answer..