Converting Number to Text
There is an Excel file that teaches how to perform the Converting Number to Text operation.
Excel Solution: Converting Number to Text
This workbook demonstrates converting number to text using VBA macros on a 65536-row data layout.
Hope it is useful.