Hello,
Could anyone please help me converting a wide range of numbers to text format. I am using the below codes:

Worksheets("Sheet1").Cells(GenCount, "AI").NumberFormat = "@"

but when I perform the below action on this cell, it gives me "Type mis-match" error

if Worksheets("Sheet1").Cells(GenCount, "AI").Value = "#N/A" .. it does not performs this check and gives me Type mi-match error 13.

Need help. Thanks