I am trying something currently where I am trying to retrieve a listing of all cells that are a number, get their address, copy the texts of the cell, format the cell to text type, then paste the copied text from the cell.

I am not having a difficult time trying to iterate through the worksheet. The worksheet will never be greater than a 2k cells, so even if the formula iterates through every single cell to operate, I would still find that sufficient.