Converting Numbers to text

[Simarpreet]

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

[ragulduy]

Do you want to Ignore cells with error or change them to text as well?
You could use:

Please Login or Register  to view this content.

I believe, but this will replace #N/A errors with #N/A as text.

[ragulduy]

Note, your check should be:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Simarpreet]

Thanks yudlugar.... ".Text" option worked perfectly. Thanks a lot for quick resolution...