Hi http://www.mrexcel.com/forum/members/mikerickson.htmlmikerickson, Your code works. I also tried cell.Value = "'" & cell and it works too. Thank you.
farmerscott, thank you for looking into this. I wanted to convert number to text because I wanted to compare two lists, which contain numeric and text. For example, if I compare 002 to 2 as value they would be the same, but in reality they are not that's why I have to convert them to text.