How to Change the cell format into text format in .csv file

[jack.chan]

is this not working for CSV file?

In this String "AB0610E001" I am using "Str.Substring(Str.Length -6)" this expression to get the last 6 digits of the String like this "10E001" but meanwhile i am entering it into excel cell i am getting like number value "100"

this then when calling you need to add sheet name parameter and column letter e.g. {“Sheet1”,“C”} for column C and sheet1 [image] Function ChangeFormatToText(sheetName As String, colLetter As String) Dim ws As Worksheet Set ws = ActiveWorkbook.Sheets(sheetName) ws.Activate Rows(1).Insert Range(colLetter & "1").Value = "test" Dim columnNumber As Integer columnNumber = Range(colLetter & "1").Column Columns(columnNumber).Select Selection.Tex…