How do I send data from a 'General' formatted cell to a 'text' formatted
cell? The end result required is a cell in 'text' format displaying the sent
data.

I wish to use a formula to do this, instead of using right-click, format
cells, select 'Text' as format.