How do I change the format of an excel workbook from General to Text

Question

I can only alter specific cells; I can't switch the entire worksheet from General to Text.

I would much appreciate any assistance. I have a syntax that is effective for single cells.

Worksheet[].number_format = numbers.FORMAT_TEXT

Answer 1

Only cells have a format for numbers. Moreover, a format may be assigned to a range (a collection of cells). Set all cells on each worksheet in the workbook to text using a loop through each worksheet. The approach will be similar; you'll only need to specify the complete sheet. This example specifies the Used Range rather than the entire page. That's not hard; I'm simply keeping the example straightforward.

Sub Format()
    Dim wkshCurrent As Worksheet
    
    For Each wkshCurrent In ActiveWorkbook.Worksheets
        wkshCurrent.UsedRange.NumberFormat = "@"
    Next wkshCurrent
End Sub