Macros used by Excel to set the cell to a number saved in text format in bulk

Start by inputting all the numbers (or exporting them) to the pound + number format, such as "#3333333323424234234234", and then run the following macro:

Sub num2text ()    If not TypeOf application.selection are Range then        MsgBox ' You must select Cells! '        Return    End If for each        cell in Application.Selection.Cells        if cell. Text <> "then              cell. FORMULAR1C1 = "'" + Replace (cell. Text, "#", "" ")        End If    nextend Sub

Macros used by Excel to set the cell to a number saved in text format in bulk